Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Alternate state in calculated dimension - Set analysis

Guys,

I have two alternate states, one is <inherited> the other one is <Healthy_Food_State>...

I have one chart table that it is in the inherited stated, but I want one dimension to be in get the possible selections in the Healthy_Food_State, and then they match...

Can you guys say to me a possible expression?

I am trying something like:

=only({$<item_substitute= ::[Healthy_Food_State]>}item_substitute)

I do suck at those kind of expressions.

Can you guys tell me a possible solution for that?

Labels (1)
3 Replies
Not applicable
Author

=only({$<item_substitute={Healthy_Food_State}::item_substitute>}item_substitute)

Not applicable
Author

it didn't work, try to see here the attachment:

in the third blue box we have the chart called "Saving"... The calculated dimension is in there. I want to get the item_id from the other state, (i want the item_id as in the second blue box, in the blue chart called "Food Price").

Not applicable
Author

PFA