topic Re: Condition differently in the Set analysis in QlikView

Condition differently in the Set analysis

warrentk80 — Tue, 27 Oct 2015 14:12:55 GMT

Goodmorning everyone

I need to enter in a formula by Set analisys to select data other than a given value

the syntax that normally use to control "if equal" is sum ({$ <[Flg Activity Type] = {'F'}>} [Total power consumption in €])

but if I have to select data other than F does not work the formula

sum ({$ <[Flg Activity Type] <> {'F'}>} [Total power consumption in €])

someone would know how to say it uses the Set analysis on the condition differently?

Thank you

Andrea

Re: Condition differently in the Set analysis

MK_QSL — Tue, 27 Oct 2015 14:23:06 GMT

({$ <[Flg Activity Type] -= {'F'}>}

Re: Condition differently in the Set analysis

sunny_talwar — Tue, 27 Oct 2015 14:30:06 GMT

or this if you don't want your expression to change based on a selection in [Flg Activity Type] and always include everything except F

({$ <[Flg Activity Type] = {'*'}-{'F'}>}