topic Re: Expression selection criteria in QlikView

Expression selection criteria

Fri, 10 Jan 2014 06:59:21 GMT

I need to exclude a specific range of products from a pivot table. Typical product no looks like "D0002456". If I want to exclude all products including a "D" in the number - what expression IF statement can I use.

Will appreciate.

Fanie

Re: Expression selection criteria

Gysbert_Wassenaar — Fri, 10 Jan 2014 07:04:30 GMT

You can add set modifiers to your expressions in your pivot table. For example sum(Amount) would become sum({<Product-={'D*'}>}Amount) to exclude Products starting with a D. If you want to use an if statement you can use something like =if(not Product like 'D*',sum(Amount))

Re: Expression selection criteria

Fri, 10 Jan 2014 07:07:13 GMT

try this

=sum({<Product={"*"}-{'D*'}>}Sales)

if you have any doubt please refer the attachment

Re: Expression selection criteria

Fri, 10 Jan 2014 07:07:50 GMT

Thank you - I will try out.