Discussions
Categories
Groups
Community Home
Categories
INTERNAL ENABLEMENT
POPULAR
THRUST SERVICES & TOOLS
CLOUD EDITIONS
Quick Links
MY LINKS
HELPFUL TIPS
Back to website
Home
Intelligence (Analytics)
Expression to get the key field instead of display field?
isstabb
I just need the appropriate syntax to retrieve the key instead of the display for a level of a dimension. In other words, these both reflect the display value:
dimension["MyGroup"]["MyLevel"]
dimension["MyGroup"]["MyLevel"]["DisplayValue"]
How do I get to the key? I tried things like:
dimension["MyGroup"]["MyLevel"]["Key"]
dimension["MyGroup"]["MyLevel"]["KeyValue"]
dimension["MyGroup"]["MyLevel"]["<KeyColumnName>"]
etc
to no avail. I'm trying to filter the crosstab by a known key.
Find more posts tagged with
Comments
isstabb
Hmm, turns out dimension["MyGroup"]["MyLevel"] is the key....when sorting. I'm only having trouble with this with filtering.