Solved: How to hide some columns in Pivot Chart - Qlik Community

kamal_sanguri · ‎2015-03-15

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

Peter_Cammaert · ‎2015-03-16

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

View solution in original post

kamal_sanguri · ‎2015-03-15

Here is the attachment...

mightyqlikers · ‎2015-03-16

hi,

do conditional enabling of expression.

Regards

Samwise

kamal_sanguri · ‎2015-03-16

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

mightyqlikers · ‎2015-03-16

Please attch your sample qvw

kamal_sanguri · ‎2015-03-16

Here it is...

simsondevadoss · ‎2015-03-16

in enable conditional , =not isnull(expression)

avinashelite · ‎2015-03-16

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.

kamal_sanguri · ‎2015-03-16

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

kamal_sanguri · ‎2015-03-16

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