topic Re: Adding values to pivot table in QlikView

Adding values to pivot table

Thu, 16 Apr 2015 05:54:15 GMT

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

Re: Adding values to pivot table

amit_saini — Thu, 16 Apr 2015 06:06:52 GMT

Try This:

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

Thanks,

Re: Adding values to pivot table

Thu, 16 Apr 2015 06:20:59 GMT

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

Re: Adding values to pivot table

PrashantSangle — Thu, 16 Apr 2015 06:25:53 GMT

Hi,

Uncheck supress Zero values from Presentation tab.

also check show all values from dimension tab.

Regards,

Re: Adding values to pivot table

amit_saini — Thu, 16 Apr 2015 06:25:56 GMT

Please share app

Thanks,
AS

Re: Adding values to pivot table

Thu, 16 Apr 2015 06:39:53 GMT

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.

Re: Adding values to pivot table

stabben23 — Thu, 16 Apr 2015 06:56:05 GMT

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.

Re: Adding values to pivot table

neha_shirsath — Thu, 16 Apr 2015 07:09:14 GMT

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.

Re: Adding values to pivot table

Thu, 16 Apr 2015 07:19:44 GMT

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.

Re: Adding values to pivot table

robert_mika — Thu, 16 Apr 2015 07:52:05 GMT

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

Re: Adding values to pivot table

stabben23 — Thu, 16 Apr 2015 07:52:46 GMT

If the dimensiontable with the country field missing UK then it will be hard. If You have UK in your dimension but you dont have any transaktion on UK yet then it is possible to show 0.

Re: Adding values to pivot table

alex_stone — Wed, 23 Dec 2015 06:50:51 GMT

Hi, how to show 0 value for missing dimension value?

Currently, we have a pivot table, it will show all dimension value when all has value.

Some dimension value will hide after we select period time.

e.g.

Dimension 1 asset risk: High, Medium, Low

Dimension 2 client risk: High, Medium, Low

Table format:

Client Risk High Medium Low

Asset Risk

High 3 6 4

Medium 4 7 2

Low 5 8 7

/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////

It will be shown as below after select period time

Client Risk Medium Low

Asset Risk

High 6 4

Medium 7 2

Low 8 7

My problem is, how to show null value or missing value for Client Risk dimension. And want to show it as below after select period time.

Client Risk High Medium Low

Asset Risk

High 0 6 4

Medium 0 7 2

Low 0 8 7

Is there any approach to solve above problem?