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: 
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.