Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Skip the ticket, Chat with Qlik Support instead for instant assistance.
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Suppress Nulls in pivot table

Hi Everyone,

I need one help from you guys,

I have a  pivot table with the sample data ad below

                         a                         b                    c

Item             Q3     Q4               Q3     Q4          Q3     Q4

aaa               -          -               145     122.1      111     222

bbb               22        -               786     88          123     122

ccc               -          -               -          34          -          22

I need the output like, if we have null values in both Quarters (Q3 and Q4) for  'a' we have to suppress the whole row, we need not to bother whether it is null or not null in 'b' or 'c'.

SO , therefore I need the output showing only one  Item='bbb'.

Please post your answers. Its urgent!!!!

0 Replies