Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Hide column in pivot table and just display the in total column

Hi,

I am making a sales forecast pivot table by customer (dimension), month (dimension). We have two expressions (sales figure, %).

I just want to show % in the partial sum total column but hide in the month column. Is there any way to do it and how?

My QV version is still 8.5. Not yet up to 9.

Thanks in advance.

Gloria

7 Replies
Not applicable
Author

You can make the table Fast Change type with Straight and Pivot, and when it is displayed as Straight Table then go to chart properties, Presentation tab, there you can check the Hide Column or even make it conditional.

Not applicable
Author

I have ticked Hide Column in Straight Table, however, when I change back to Pivot Table view, the column is still appearing.

Also, is 8.5 supports hide column to be conditional?

Not applicable
Author

Hi, here's an example demostrate my problem. Please help~~ Many thanks.

Not applicable
Author

Hi,

I don't know if i understand you right, but if you go to the expression, there you mark %, and take away the enable.

best regards

Malin

Not applicable
Author

Hi,

If I uncheck the enable in the % expression, I couldn't see the % in Total (The last column) as well. I need to have the % Total at the end but not needed on month level.

Not applicable
Author

I want to do that in pivot table. Any idea how to do that?

Not applicable
Author

Hi Gloria

I've got exactly the same problem to solve, Have you found a solution by now?

Regards

Rainer