Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
AWS Degraded - You may experience Community slowness, timeouts, or trouble accessing: LATEST HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
guyvermeiren
Creator
Creator

Blank Column in pivot when using calculated dimension

Hello,

I created a pivot table using a calculated dimension.

When totally collapsed the table occurs with a blank column after the first (calculated) dimension.

Capture.GIF

What's the reason for this ?

Thanks

Guy

 

3 Replies
Channa
Specialist III
Specialist III

is it possible to share APP or sample data or expression

Channa
guyvermeiren
Creator
Creator
Author

This is the expression for the calculated dimension:

=if(Match([Organization],'Belgium','Netherlands','France','Germany'),[Account Mngr],null())

 

Kind regards,

Guy

Channa
Specialist III
Specialist III

Try remove else null
Try with out calculation do you have customers for west, North... Check
Channa