4 Replies Latest reply: Oct 17, 2017 7:10 AM by Richard Bartley RSS

    Qlik Sense - Changing dimensions based on selections

    Richard Bartley

      Hello everyone,

       

      I have a Qlik Sense app with a number of fields in the selection panel and a line chart.  The chart has two dimensions: the time dimension and the reference period, which allows me to compare prices over different years, with each year represented by a different line.  To prevent the lines showing averages, I have a calculation condition which forces the user to make a number of selections.  However, because of the number of dimensions and the length of the text, the legend is extremely long and so, I would like to be able to choose which fields appear in the legend, e.g. if(count(field a)>1,field a,if(count(field b)>1,field b,etc.....  However, when I try to implement this, it returns an invalid dimension. Does anyone know whether it is possible to change the field (not the value) based on the number of selections from a given field?

       

      Thanks in advance,

       

       

      Richard