Discussions
Categories
Groups
Community Home
Categories
INTERNAL ENABLEMENT
POPULAR
PUBLIC CLOUD
PRIVATE CLOUD
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.