topic Re: Showing Disabled Dimension in Pivot Table in QlikView

Showing Disabled Dimension in Pivot Table

Tue, 10 Jun 2014 17:00:39 GMT

Hi all,

I am using C1,C2,C3,C4 AND C5 as dimension

and

E1 as expression

Now when ever C3 is going null, it is not showing the C4 and C5 and it is summing the E1 based on C1,C2 and C3.

Because of this, my values, which are changed in C4 and C5 are not getting displayed.

Is there any way so that I can still show the C4 and C5 even after C3 is null.

Your help is required in urgent.

Thanking in advance

Message was edited by: Keshav Singh The app and data source is attached. Please help me in doing it.

Re: Showing Disabled Dimension in Pivot Table

Tue, 10 Jun 2014 17:01:56 GMT

Make sure "suppress when null" is unselected for all of your dimensions, also select "Show all values".

You can find these options under chart properties -> dimensions

Re: Showing Disabled Dimension in Pivot Table

Wed, 11 Jun 2014 05:02:41 GMT

Hi Jacob,

I did the same as you told.

but it is still not working.

Any other solution?

Thanking in advance.

Re: Showing Disabled Dimension in Pivot Table

Thu, 12 Jun 2014 05:30:49 GMT

HI all,

Here urgent help is required guys

Please help me in solving this issue

thanking in advance.

Re: Showing Disabled Dimension in Pivot Table

SergeyMak — Thu, 12 Jun 2014 05:42:08 GMT

Can you share the app?

Re: Showing Disabled Dimension in Pivot Table

Thu, 12 Jun 2014 09:16:00 GMT

How can i attach my .qvw and .csv files??

I don't know it

please help me in that

Re: Showing Disabled Dimension in Pivot Table

dharmarasu — Thu, 12 Jun 2014 09:59:30 GMT

Hi keshav,

it is not possible to show the values ,if the dimensions is empty in PIVOT.

if u want to show straight table is the only way.

In pivot u can demote the empty dimension(NewString) to last, then it will work...otherwise it wont.

Even if u supress the null values in dimension also.

dharma

Re: Showing Disabled Dimension in Pivot Table

SergeyMak — Fri, 13 Jun 2014 00:46:22 GMT

If you press "-" in NewString and then press "+" as you will get your C4 and C5 dimensions.

Try to use "Always fully expanded" on the presentation tab.