topic Re: How to hide some columns in Pivot Chart in QlikView

How to hide some columns in Pivot Chart

kamal_sanguri — Mon, 16 Mar 2015 03:32:06 GMT

Hi,

I am just trying to find out a way to hide some expression columns where there is no value...

For example, I do not want to show the highlighted columns as they do not have any value...

Any help would be greatly appreciated... Thanks much in advance.

Attaching the file as well..

Kamal

Re: How to hide some columns in Pivot Chart

kamal_sanguri — Mon, 16 Mar 2015 03:39:01 GMT

Here is the attachment...

Re: How to hide some columns in Pivot Chart

mightyqlikers — Mon, 16 Mar 2015 04:05:05 GMT

hi,

do conditional enabling of expression.

Regards

Samwise

Re: How to hide some columns in Pivot Chart

kamal_sanguri — Mon, 16 Mar 2015 04:16:34 GMT

Thanks for the reply.. I have already tried that but didn't get the result.

Re: How to hide some columns in Pivot Chart

mightyqlikers — Mon, 16 Mar 2015 04:19:17 GMT

Please attch your sample qvw

Re: How to hide some columns in Pivot Chart

kamal_sanguri — Mon, 16 Mar 2015 04:22:25 GMT

Here it is...

Re: How to hide some columns in Pivot Chart

simsondevadoss — Mon, 16 Mar 2015 05:05:23 GMT

in enable conditional , =not isnull(expression)

Re: How to hide some columns in Pivot Chart

avinashelite — Mon, 16 Mar 2015 05:13:37 GMT

Hi Kamal,

I saw your data file, you can hide the column only when the entire column data is null or zero. In your case you have few data here and their and entire column is not empty.

Re: How to hide some columns in Pivot Chart

kamal_sanguri — Mon, 16 Mar 2015 05:44:59 GMT

Hello Avinash,

Yes.. there is data in column... If there is nothing in the column.. there is no reason for that column to be there...

Nevertheless... can you think of any other way apart from conditional enable .. probably changing in data format or may the pivot chart format... thay may resolve the problem..

Thanks much,

Kamal

Re: How to hide some columns in Pivot Chart

kamal_sanguri — Mon, 16 Mar 2015 05:45:46 GMT

Thanks for ur time and reply... I don't think this can be achieved with conditional enable...

Re: How to hide some columns in Pivot Chart

Peter_Cammaert — Mon, 16 Mar 2015 07:59:49 GMT

There is a technique that allows you to hide expression columns that do not contain any (sensible) data from Pivot Tables. It works by turning the expressions into dimension values of their own. In your case, those would be 'YTD Incurred' and 'FY Forecast' that should become dimension values.

See this discussion for a thorough explanation: Logic

Best,

Peter

Re: How to hide some columns in Pivot Chart

timanshu — Mon, 16 Mar 2015 11:38:18 GMT

Hi Kamal,

write this in conditional :

sum(TOTAL sum([Fy Forecast]))<> 0 and not isnull( sum(TOTAL sum([Fy Forecast])) )

Re: How to hide some columns in Pivot Chart

kamal_sanguri — Mon, 16 Mar 2015 14:55:40 GMT

It didn't work..

Re: How to hide some columns in Pivot Chart

Peter_Cammaert — Mon, 16 Mar 2015 16:07:17 GMT

Like you said, tricks with Conditional Show won't work here because they are bound to suppress all instances of the expression.

For a technique that does work, see here: http://community.qlik.com/message/731240#731240

Re: How to hide some columns in Pivot Chart

timanshu — Tue, 17 Mar 2015 04:29:47 GMT

Hi kamal,

Kindly see the attached qvw.

It works.

Re: How to hide some columns in Pivot Chart

kamal_sanguri — Tue, 17 Mar 2015 13:10:00 GMT

Hello,

This method does not work... it hides FY Field entirely.. Please check for 2015--March

We have figures for 2015-Mar but it hides that as well...

Thanks,

Kamal

Re: How to hide some columns in Pivot Chart

kamal_sanguri — Tue, 17 Mar 2015 13:12:11 GMT

Hi Peter,

Although it took me long to understand and incorporate the logic in my app but it worked..

Re: How to hide some columns in Pivot Chart

Peter_Cammaert — Tue, 17 Mar 2015 13:18:17 GMT

In the future, never hesitate to ask additional questions about tricks that may look obscure at first. I already did more than a few wrestling matches with QlikView and gladly would have tried to spare you from them.

Re: How to hide some columns in Pivot Chart

timanshu — Wed, 18 Mar 2015 04:52:24 GMT

Hi Kamal,

Ok. My mistake. The method will not work for you. Can you explain me the way you done or if you could just attached qvw with issue resolved?