topic Alternate States and set analysis in QlikView https://community.qlik.com/t5/QlikView/Alternate-States-and-set-analysis/m-p/621354#M681531 <HTML><HEAD></HEAD><BODY><P>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...</P><P></P><P>the item_id that are supposed to appear are like D,E,F,G...</P><P></P><P>Can you guys help me out with this set analysis?</P></BODY></HTML> Thu, 10 Apr 2014 01:26:01 GMT 2014-04-10T01:26:01Z Alternate States and set analysis https://community.qlik.com/t5/QlikView/Alternate-States-and-set-analysis/m-p/621354#M681531 <HTML><HEAD></HEAD><BODY><P>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...</P><P></P><P>the item_id that are supposed to appear are like D,E,F,G...</P><P></P><P>Can you guys help me out with this set analysis?</P></BODY></HTML> Thu, 10 Apr 2014 01:26:01 GMT https://community.qlik.com/t5/QlikView/Alternate-States-and-set-analysis/m-p/621354#M681531 2014-04-10T01:26:01Z Re: Alternate States and set analysis https://community.qlik.com/t5/QlikView/Alternate-States-and-set-analysis/m-p/621355#M681532 <HTML><HEAD></HEAD><BODY><P>Hi.</P><P></P><P>It's incorrect syntax. Use square brackets to get the alternate state.</P><P>Also for calculated dimension you have to use aggr() function.</P><P></P><P><SPAN style="color: #0000ff; font-size: 8pt;">aggr</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">only</SPAN><SPAN style="font-size: 8pt;">({$&lt;</SPAN><SPAN style="color: #800000; font-size: 8pt;">item_id</SPAN><SPAN style="font-size: 8pt;">=</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">[Healthy_Food_State]</SPAN><SPAN style="font-size: 8pt;">::</SPAN><SPAN style="color: #800000; font-size: 8pt;">item_id</SPAN><SPAN style="font-size: 8pt;">&gt;}</SPAN><SPAN style="color: #800000; font-size: 8pt;">item_id</SPAN><SPAN style="font-size: 8pt;">), </SPAN><SPAN style="color: #800000; font-size: 8pt;">item_id</SPAN><SPAN style="font-size: 8pt;">) </SPAN></P><P></P></BODY></HTML> Thu, 10 Apr 2014 06:05:09 GMT https://community.qlik.com/t5/QlikView/Alternate-States-and-set-analysis/m-p/621355#M681532 whiteline 2014-04-10T06:05:09Z Re: Alternate States and set analysis https://community.qlik.com/t5/QlikView/Alternate-States-and-set-analysis/m-p/621356#M681534 <HTML><HEAD></HEAD><BODY><P>Thank you, but it is not showing what I want...</P><P></P><P>The selection is: "Hamburguer" in the first blue box, and then "Hamburguer Replacement" in the second blue box...</P><P></P><P>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....</P><P></P><P>Do you know how to make that work this way?</P></BODY></HTML> Thu, 10 Apr 2014 12:49:50 GMT https://community.qlik.com/t5/QlikView/Alternate-States-and-set-analysis/m-p/621356#M681534 2014-04-10T12:49:50Z