topic Re: Pivot table- How to hide colums? in QlikView

Pivot table- How to hide colums?

Mon, 01 Jun 2015 16:47:42 GMT

Hello All,

I am building two pivot tables having the same content. One for MTD and the other for YTD.

The two tables have same dimensions. I want to place the two tables next to each other. But, i want to display the dimension only once.

How can i hide the column in the second table?

Thanks,

Deepti

sunny_talwar — Mon, 01 Jun 2015 19:41:58 GMT

Why don't you use two expressions instead of using two different Pivot Tables? Is there a reason you are doing that?

Best,

Sunny

pratap6699 — Mon, 01 Jun 2015 19:53:58 GMT

conditionally disable that expression....or dont use another same expression

Mon, 01 Jun 2015 19:56:16 GMT

Hi sunny,

Please find the sample screeshot attached.

This is the kind of display I need.

For YTD table, I have placed underneath the MTD table so as to hide the repetitive columns(KPINames,Target,).

But, when i apply filters, these hidden columns pop up. how can i avoid that?

Thanks,

Deepti

sunny_talwar — Mon, 01 Jun 2015 20:05:46 GMT

For the MTD Table try un checking 'Size to Data' on the Layout tab of chart properties and see if that helps:

This will show you white space instead of reducing the size of the table when you make a selection for filtration.

Best,

Sunny