topic Re: show all dimension values in QlikView

show all dimension values

tyagishaila — Thu, 16 Jul 2015 07:26:34 GMT

Hi All,

I have some stores which are yet to open, that's why in sale table we have no data against that store.

But when we create chart we need to show all stores, for those store which are yet to open sale can be '0' or '-'.

My problem is that , My pivot table is not showing those stores for which no sale happen.

Please help me, how can I show all stores.

Thanks,

Re: show all dimension values

Kushal_Chawda — Thu, 16 Jul 2015 07:35:55 GMT

Go to Pivot table properties -> Presentation Tab-> Uncheck suppress zero- values

Re: show all dimension values

tyagishaila — Thu, 16 Jul 2015 07:44:32 GMT

Thanks for quick reply,

I have done it, I have also checked Show All Values for dimension

Problem is, expressions don't have Zero value,

these stores are not open, So sale table has no data against these stores.

Re: show all dimension values

Kushal_Chawda — Thu, 16 Jul 2015 07:50:16 GMT

what is the expression you are using?

Try below expression and then do the setting as I suggested before

if(isnull(sum(sales)) ,0,sum(sales))

Also uncheck suppress null values for dimension

Re: show all dimension values

tyagishaila — Thu, 16 Jul 2015 07:51:57 GMT

Sorry,

I have done it also.

but problem still same.

Re: show all dimension values

antoniotiman — Thu, 16 Jul 2015 07:52:11 GMT

Try

Alt(Sum(Sales),0)

Re: show all dimension values

Thu, 16 Jul 2015 07:59:09 GMT

I feel there is some other problem which is causing this otherwise unchecking 'Supress Zero-Values' should work. Please upload sample QVW and data.

Regards,

KKR

Re: show all dimension values

avinashelite — Thu, 16 Jul 2015 08:02:00 GMT

try like this:

Go to>presentation tab> uncheck populating missing > and un check the suppress missing this should help you in getting the values .

please find the attached sample

Re: show all dimension values

tyagishaila — Thu, 16 Jul 2015 08:04:27 GMT

Thanks MANCINI,

Alt() also not useful for me, What Alt() does.

Re: show all dimension values

antoniotiman — Thu, 16 Jul 2015 08:08:54 GMT

Alt(x,y)

If x espression is valid expression (e.g. non null) returns x, else y

Regards

Re: show all dimension values

avinashelite — Thu, 16 Jul 2015 11:10:36 GMT

dis you check the attachment ?? in the previous post

Re: show all dimension values

Thu, 16 Jul 2015 11:41:07 GMT

Hi,

PFA, you just have to do some changes in presentation tab.

Re: show all dimension values

Thu, 16 Jul 2015 12:30:41 GMT

Could you share your QV app or let me know the expression you are using?

Re: show all dimension values

tyagishaila — Thu, 16 Jul 2015 13:54:58 GMT

Yes Avinash, I have checked but its not working.

Thanks for time,

Re: show all dimension values

avinashelite — Fri, 17 Jul 2015 05:00:54 GMT

we are not able to replicate the error can you please share your app?? or create a sample data and share with us