Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
BI & Data Trends 2021. Discover the top 10 trends emerging in today. Join us on Dec. 8th REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

Show Dimension even if no value in expression

I have requirement where I have to show the country dim in straight table even if there is zero in the data.
If I select the Country 'C' in below table I will not see the record for Country 'C'.
But I want it to show the country dim with '0'.
Can any one help me on it.

Country Filter  
   
CountryDim2Sales
AX10
BY20
CZ0
5 Replies
Highlighted
Creator
Creator

Click on include null values .. in the dimension 

Highlighted
Contributor III
Contributor III

Yes already its checked, but no result

Highlighted
Creator
Creator

Hey Rajesh ,

 

What error are you getting ??

Sales as 0 

clipboard_image_1.png

 

 

 

Highlighted
Partner
Partner

Hello,

I also have a similar requirement to show the all the dimension value even if it does not have any measure value.

I want to implement the same in Pivot table.

Any responses are highly appreciated.

Please find sample data.

 

 

Req.PNG

 

Regards,

Madhavi 

 

Highlighted
Specialist II
Specialist II

Can you please share a sample app where you are having the problem? It would make it much easier to understand correctly the issue