Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Set Expression help

Hello QV,

I have below expr in my chart.

sum({<Segment={'Group'}, Status = {'Cancelled'}>}[REV YTD])/1000000

Now my requirement is to exclude Cancelled Accounts, means Status is not equals to 'Cancelled'.

How to write the expr for the same.

Thanks,

Ananth

1 Solution

Accepted Solutions

Re: Set Expression help

Try with

sum({<Segment={'Group'}, Status = {'*'}-{'Cancelled'}>}[REV YTD])/1000000


means all minus cancelled

14 Replies
simondachstr
Valued Contributor III

Re: Set Expression help

sum({<Segment={'Group'}, Status -= {'Cancelled'}>}[REV YTD])/1000000


A minus before the = should exclude it

Re: Set Expression help

Try with

sum({<Segment={'Group'}, Status = {'*'}-{'Cancelled'}>}[REV YTD])/1000000


means all minus cancelled

Not applicable

Re: Set Expression help

Sorry, both are not working...

Re: Set Expression help

Hi,

this must work

sum({<Segment={'Group'}, Status -= {'Cancelled'}>}[REV YTD])/1000000


If not post sample data.


Regards

ASHFAQ

Not applicable

Re: Set Expression help

I'm getting error, if I write above expr

Expr.png

Re: Set Expression help

I'm sure the syntax is correct, explain with more details, why you say it doesn't work?

Re: Set Expression help

It gives error but gives you proper result

To avoid that you have been provided second expression

Which does the same

sum({<Segment={'Group'}, Status = {'*'}-{'Cancelled'}>}[REV YTD])/1000000


Regards

ASHFAQ

mr_novice
Contributor II

Re: Set Expression help

The editor dont understand the syntax but it should work...

Re: Set Expression help

Hi,

Even if there is red line but it will give you correct output.

Check it.

Regards

Regards,
Prashant Sangle
Community Browser