Filter on straight table

[jrbrutto]

Hi all,

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

Code	Difference	Qty 1	Qty 2
09305002XYR0007	0	1,848	1,848
09305005XYR0B00	462	924	462
09305005XYR0007	0	693	693
09305006XYR0006	0	462	462

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]

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

[QlikEnth]

Try Using the below:

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

[Digvijay_Singh]

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