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




      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!