Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Alternate States and set analysis

Guys, I am having a trouble trying to make it appear the "item_id" from the state "Healthy_Food_State", in the chart "Saving" (in the third blue box in the table...

the item_id that are supposed to appear are like D,E,F,G...

Can you guys help me out with this set analysis?

2 Replies
Honored Contributor II

Re: Alternate States and set analysis


It's incorrect syntax. Use square brackets to get the alternate state.

Also for calculated dimension you have to use aggr() function.

aggr(only({$<item_id=[Healthy_Food_State]::item_id>}item_id), item_id)

Not applicable

Re: Alternate States and set analysis

Thank you, but it is not showing what I want...

The selection is: "Hamburguer" in the first blue box, and then "Hamburguer Replacement" in the second blue box...

If you then put the "item_id" in a list, you will see in the "inherited" state the number 1 only, if you change to "Healthy_Food_State", it will show F,E,G,D... It seems that the field in the Healthy_Food_State is not being shown....

Do you know how to make that work this way?

Community Browser