Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Filtering data in a pivot table

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.

3 Replies
SunilChauhan
Champion
Champion

see the attached file

by spress null values in

EPONYM_ΕΠΩΝΥΜΟ

hope this help

Sunil Chauhan
its_anandrjs

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

kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi,

    Try this expression.

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

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!