Need to exclude a filter

[muhammedraleen]

Hi All,

QlikView Desktop

I have written an expression, where it consists of 3 summations with inner set expressions. Now, i need to exclude the company filter selection. If i put Company= in all 3 summations , its working but i need to mention in it once. I tried an outer set expression for this, but it's not working.

Outer expression :- {<Company=>} Sum({$<Jun={'Yes,TIW'}>} Amount)
                                                         +
                                                        Sum({$<Jun={'Yes','Yes,TIW'}>} Amount)

Can anyone please help me on this?

[lennart_mo · Accepted solution]

Hi @muhammedraleen,

I had to look it up in the Qlik Documentation myself but apparently using the '$' in the inner set expressions overrides the outer expression, so by deleting those should fix your issue.

Hope this solves your problem!

[muhammedraleen]

Hi @lennart_mo ,

Thanks for the support, it is working.