Adding values to pivot table

[#1]

hi i am poppulating a pivot table like

count({<country={'India',USA,'Canada','UK'}>}country).My table contains India,USA,and Canada.But i want to show UK and corresponding number of users as 0.I have attached the screenshot of my pivot table.Is that possible

[amit_saini]

Try This:

If(Country='UK' , 0 , count({<country={'India',USA,'Canada'}>}country))

Thanks,

AS

[#3]

hi,thanks for looking in to the issue,but it not worked for me

[PrashantSangle]

Hi,

Uncheck supress Zero values from Presentation tab.

also check show all values from dimension tab.

Regards,

[amit_saini]

Please share app

Thanks,
AS

[#6]

Hi i think my  explanation is not enough.Actually i am loading the values from database and there no row such row 'uk'.My condition is that when the number of countries increase say 50,then when using this count expression and if country name is not database then i have to show the country name and the corresponding number of users as 0 in my pivot table.

[stabben23]

If you dont have the Dimension data (UK) then qlikview is not able to show it. If you want to have it in your pivot then you have to add it in some way in your datamodel, maybe as an inline table.

[neha_shirsath]

Hi,

I'm not getting your question exactly. You are saying-

My condition is that when the number of countries increase say 50,then when using this count expression and if country name is not database then i have to show the country name.

Means if country increases above 50 then suppose you have country as US then also for this it will show as UK?? or when above 50 count country is blank or Null then it will show UK?

Regards,

Neha S.

[#9]

no,I want to know if the value UK is not in the database and using the count expression is it possible to show Country as UK and Number of users as 0.

[robert_mika]

If UK is not in database in will not be shown...