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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources 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?

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