Qlik Community

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Arthur_Fong
Partner
Partner

Suppressing second dimension when null

Hi all,

Is there a way that I can suppress the null value for the second dimension in a pivot table, but first dimension still remains? 

Sample table is located below:

load DD1,IF(LEN(DD2)<1,NULL(),DD2)AS DD2,Value inline [
DD1,DD2,Value
A,A1,100
B,,200
];

What I would want to achieve is to get a pivot table that shows:

PIVOT.PNG

Since B has no DD2, it should not show anything(including null) in the second dimension.
If I uncheck the null value for second dimension in pivot table properties, this will not show the value for B.

Any workaround for this?

Thanks and regards,
Arthur Fong

 

 

0 Replies