6 Replies Latest reply: Sep 26, 2016 4:41 PM by Gilberto Souza RSS

    Hide dimensions in charts

    Marc LOUESSE

      Hi all,

      I'm a self made user of QV11 and I have a question about how to hide a dimension of a chart.

       

      Here is the situation :

      I'm loading my data from an excel file.

      In order to custom the sorting order of my chart, I "left join" another excel file with the sorting order values (1, 2, 3, etc...)

      For the data not matching with the sorting order file, I map the value 999.

       

      So to illustrate, I have :

       

      Data file :

      [item]

      A

      B

      C

      D

       

      Sorting file :

      [item],[sort order]

      A,3

      B,1

      C,2

       

      Which gives me the table after mapping :

      [item],[sort order]

      A,3

      B,1

      C,2

      D,999

      (plus all the values in the data files)

       

      So in my chart, I show the different items as dimension, the values I want to show and I sort my items using the expression [sort order].

      I then have showed :

      B, C, A, D

       

      That works perfectly but now I want to have the possibility to hide all the dimensions not present in my sorting file (so all the dimensions having 999 in [sort oder]).

      If possible, I would like to use a kind of switch button "show/hide".

       

      Do you know how I could do it ?

       

      Marc