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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Newbie777
Partner - Creator III
Partner - Creator III

Pivot showing null for month year column

Hello,

I created sales pivot table by customers with month year data, and although there are all the date fields with no null data, I have a column showing empty data, while other columns show proper month year figures.  I'd appreciate it if someone could let me know how to fix this.  

Newbie7_0-1629207330962.png

 

1 Solution

Accepted Solutions
Newbie777
Partner - Creator III
Partner - Creator III
Author

OK. I just solved it by unticking "Include null values" tickbox.  

View solution in original post

1 Reply
Newbie777
Partner - Creator III
Partner - Creator III
Author

OK. I just solved it by unticking "Include null values" tickbox.