topic Re: Filtering data in a pivot table in QlikView

Filtering data in a pivot table

Mon, 03 Oct 2011 13:26:48 GMT

At this qvw, the problem is that i want to show only the rows that have the expression Quantity <> 0. How i can filter rows. I try to use calculation condition or the conditional show but it doesn't work.

Re: Filtering data in a pivot table

SunilChauhan — Mon, 03 Oct 2011 13:33:05 GMT

see the attached file

by spress null values in

EPONYM_ΕΠΩΝΥΜΟ

hope this help

Re: Filtering data in a pivot table

its_anandrjs — Mon, 03 Oct 2011 13:36:44 GMT

Hi,

Write this in all expression

If(sum(COP_QTY*POSOT_ΠΟΣΟΤΗΤΑ) > 0, sum(COP_VAL*AXIA_ΚΑΘΑΡΗ_ΑΞΙΑ))

If(sum(COP_QTY*POSOT_ΠΟΣΟΤΗΤΑ) > 0, TEM_ANA_SYS)

If(sum(COP_QTY*POSOT_ΠΟΣΟΤΗΤΑ) > 0,sum(COP_QTY*POSOT_ΠΟΣΟΤΗΤΑ))

Rgds

Anand

Filtering data in a pivot table

kaushiknsolanki — Mon, 03 Oct 2011 13:38:08 GMT

Hi,

Try this expression.

sum(if((COP_QTY*POSOT_ΠΟΣΟΤΗΤΑ )<>0,COP_QTY*POSOT_ΠΟΣΟΤΗΤΑ))

Regards,

Kaushik Solanki