topic Re: Filter on straight table in QlikView

Filter on straight table

jrbrutto — Wed, 25 Nov 2020 16:16:04 GMT

Hi all,

I have a simple table with a dimension (Part Number), two expressions (Quantities) and a calculated dimension (difference)

I would to filter the table to have only the codes with a difference <> 0. In this case it would show only this:

Code	Difference	Qty 1	Qty 2
09305005XYR0B00	462	924	462

I tried many things as conditional or dimensions limit but no-one works. Any suggestions?

Thanks

sunny_talwar — Wed, 14 Feb 2018 17:56:33 GMT

What is the expression you use behind the calculated dimension Difference?

QlikEnth — Wed, 14 Feb 2018 18:17:47 GMT

Try Using the below:

=if(difference<>0,1,0)

Digvijay_Singh — Wed, 14 Feb 2018 18:37:36 GMT

What if you create measure for difference, and use measure for Qty1,Qty2 and difference like below -

- If(Sum(Qty1)-Sum(Qty2)<>0, Sum(Qty1))

- If(Sum(Qty1)-Sum(Qty2)<>0, Sum(Qty2))

- If(Sum(Qty1)-Sum(Qty2)<>0, Sum(Qty1)-Sum(Qty2)) //Difference measure

In Add-on properties, disable 'show zero values' if needed