2 Replies Latest reply: Apr 10, 2014 8:49 AM by Julio Lourenco RSS

    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?

        • Re: Alternate States and set analysis
          whiteline _

          Hi.

           

          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)

           

            • 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?