Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Qlik Insider: SaaS capabilities for Data Integration and Analytics, May 25th! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
selvakumara
Creator
Creator

Want to show null values

     Hi Guys,

I have a reqiurement  like below,

If you selected a fiscal year = 2018 , (Jun-17 to Nov-17 as of now)

The bar chart will show the values from jun 17 to nov 17. Even any of the month doesn't contain values it will show zero.

But, If i selected any value from Donut it will show only Aug,Oct,Nov. Rest of the months was disappeared.

Here is my expression.

Before Click the Donut the below expression working

Count({$<[Group]={'xsdssds'}>} DISTINCT Record)

+ 0*Count(DISTINCT Record)

After click the the donut some of the months was not displayed12.PNG13.PNG

1 Reply
Chanty4u
MVP
MVP

data handling  tick include null values and  

in dimension tab also  tick show null values