7 Replies Latest reply: Jun 19, 2017 9:50 AM by Tatiana Nouteping Fomo RSS

    How to use conditions set analysis expressions

    Tatiana Nouteping Fomo

       

      Hello,

       

      I am new to Qlikview and therefore new to set annalysis. I want to calculate a turnover of different period

      I have created the following expression:

       

      = round(sum({<PARA_DATE={Jour travaillé -1},STATUS={Fermé} >} MONTANTEURO )) .

       

      The variable PARA_DATE has three options which are 'Aujourd'hui', 'Jour travaillé +1' and 'Jour travaillé +2'.

       

      The expression works perfectly but only with the option 'Aujourd'hui' on PARA_DATE maybe because the other two options have more than one word.

       

      Is there a way to make it work with the other two options? Help!

       

      Thanks,

       

      Tatiana