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: 
grajmca_sgp123
Creator
Creator

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
Labels (1)
5 Replies
AdiPai
Creator II
Creator II

Click on include null values .. in the dimension 

grajmca_sgp123
Creator
Creator
Author

Yes already its checked, but no result

AdiPai
Creator II
Creator II

Hey Rajesh ,

 

What error are you getting ??

Sales as 0 

clipboard_image_1.png

 

 

 

madhavi_rajawat
Partner - Contributor III
Partner - Contributor III

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 

 

lorenzoconforti
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