How to use conditions set analysis expressions

[#1]

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

[sunny_talwar · Accepted solution]

Add a single quote for when you have spaces.... and also is it + 1 or -1?

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

or

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

[jonathandienst]

Is this what you mean?

=Round(Sum({<

     PARA_DATE={'Aujourd'hui', 'Jour travaillé +1' ,'Jour travaillé +2'},

     STATUS={Fermé}

>} MONTANTEURO )) .

[#4]

It works now. Thank you !

[#5]

Thank you for your help Jonathan but i wanted to do it separately as i am using different Text objetcts for each. but it's fine now my problem was the quotes.

[#6]

I please have another question. how can i add the euro symbol: '€' in that same expression?

[sunny_talwar]

Since this is text box object, you can do this

='€' & Round(Sum({<PARA_DATE={'Jour travaillé -1'},STATUS={Fermé}>} MONTANTEURO))

or you can use Num() function

=Num(Round(Sum({<PARA_DATE={'Jour travaillé -1'},STATUS={Fermé}>} MONTANTEURO )), '€#,##0')

[#8]

Thank you!