Show all even if the value is null

[n1ef5ng1]

Hi, I have a pivot table that has Country on the Column row.

In my Country field, it contains all the countries in the world. However, I am only interested in few of the countries on my pivot table

Therefore, this is the code i used to 'filter' the countries that I want

=Sum({<
Country={'South Africa','Pakistan','Iran','Saudi Arabia','United Arab Emir'}

>} Sales) 

However, certain countries have value that is zero and Qlikview will not display the Country that has zero in value.

Is there any way i can list out ALL the countries that i want even though there is zero value?

[#2]

In pivote chart--

Dimension--  Country

Expression -- 

=Sum({<Country={'South Africa','Pakistan','Iran','Saudi Arabia','United Arab Emir'}>} Sales) 

Then go to presentation tab of pivot --> select your field Sales-->and uncheck the supress Zero value

Then you get the desired result.

see attachement

[n1ef5ng1]

Tried but can't

my code comes with condition too

=Sum({<
Country={'South Africa','Pakistan','Iran','Saudi Arabia','United Arab Emir'}

,Code={'CL'}
,Name={'Laeen'}

>} Sales) 

[thomas_skariah]

Hi,

You can try the below attached application.

Regards,

Tom