topic Pivot table in QlikView

Pivot table

Mon, 27 Dec 2010 06:35:40 GMT

Hi,

I have created a pivot table with two dimesions and one expression. In such a way it will display the region and Month and according count (Expression values). Since it is pivot table i have made the month from rows in to columns. it is working fine but displayed coumn heading is still showing. I want to hide the column, Attached the screenshot for your reference

Pivot table

tresB — Mon, 27 Dec 2010 08:30:36 GMT

Hi,

Try this: Label the CT as ''. and then pull the column bar (of CT) to the minimum. it is almost like hiding.

regards, tresesco

Pivot table

sunil2288 — Mon, 27 Dec 2010 08:43:42 GMT

Hi XXX,

In Presentation tab Click on the Dimension CT.

Then below there is a check box called Supress Missing...Click on that ..

It will Solve your problem.

Regards

Sunil

Pivot table

Mon, 27 Dec 2010 09:36:38 GMT

Hi Sunil,

I have enabled supress Missing check in the Presentation tab. But it is not getting suppressed.

Pivot table

sunil2288 — Mon, 27 Dec 2010 09:41:26 GMT

Hi XXX,

Try fro supress Zero Value checked... and Supress Missing checked.

Regards

Sunil

Pivot table

Mon, 27 Dec 2010 14:19:50 GMT

Hi Sunil,

Still the same result. Also i have referred the below link. http://community.qlik.com/forums/t/38613.aspx .As per that it can be done only through macros. I am trying to supress using macro.

Pivot table

sathishkumar_go — Mon, 27 Dec 2010 14:38:58 GMT

Go to chart right click --> properties-->Dimension

select CT Dimension after Label Button 1 text box is there?

select mouse pointer in that text box, after give 1 space and select ok button

in chart CT will not come but it will show some space.

Hopw it will helpful for u

Regards

Sathish

Pivot table

marcohadiyanto — Mon, 27 Dec 2010 14:42:01 GMT

hi,

where CT come from?

i think from Dimension