Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

warrentk80
New Contributor III

Condition differently in the Set analysis

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



1 Solution

Accepted Solutions

Re: Condition differently in the Set analysis

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

2 Replies

Re: Condition differently in the Set analysis

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

Re: Condition differently in the Set analysis

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

Community Browser