3 Replies Latest reply: Nov 8, 2016 12:43 PM by Shahbaz Khan Mohammed RSS

    Set Analysis applied to a dimension

    Giuseppe De Vivo

      Hi all,


      I'm trying to calculate a dimension column with this expression:


      $(=Only( {$<dimension1={'$(vVarCase)'}> + <dimension1={'1'}> } dimension1))


      Dimension1 has only '0' or '1' values and I need to obtain 2 different case:


      1) To show only '1' value

      2) To show both value '1' and '0'


      How do the user can choose the case?

      He has a select box with 2 value "OFF" = 0 and 'ON' = 1.

      The select box is linked to a varaiable 'vVarCase' that is '0' or '1'.


      When the user chooses ON then, I need to show che case number 1, if he chooses OFF I need to show the case 2.


      I tryed to apply set analysis to my dimension, but it doesn't work.


      Can somone help me, please?


      Thank you in advance.