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

# How to use conditions set analysis expressions

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

• ###### Re: How to use conditions set analysis expressions

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 ))

• ###### Re: How to use conditions set analysis expressions

It works now. Thank you !

• ###### Re: How to use conditions set analysis expressions

Is this what you mean?

=Round(Sum({<

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

STATUS={Fermé}

>} MONTANTEURO )) .

• ###### Re: How to use conditions set analysis expressions

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.

• ###### Re: How to use conditions set analysis expressions

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

• ###### Re: How to use conditions set analysis expressions

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')