topic Re: PIVOT TABLE ISSUE in QlikView

PIVOT TABLE ISSUE

Tue, 04 Mar 2014 13:57:01 GMT

Attached is the Desired Reult I am trying to Achieve, But I dont want the First Column( TOT1 and TOT 2). I am using a Pivot Table right now but I wanna use the Straight Table. If Possible.

Re: PIVOT TABLE ISSUE

Tue, 04 Mar 2014 14:14:32 GMT

In straight table

Go to Presentation >> Hide Columns.

Will hide your desire column.

Vinay

Re: PIVOT TABLE ISSUE

Tue, 04 Mar 2014 14:47:56 GMT

I am using the PIVOt Table

Re: PIVOT TABLE ISSUE

Anonymous — Tue, 04 Mar 2014 15:01:25 GMT

Hi Ray,

Hide First Column( TOT1 and TOT 2) - do you want to hide columns and calculate only remaining column values

In Straight table - grouping of dimensions is not possible like pivot table.

Pivot table - grouping of dimensions is possible in pivot table,it is often used with sub-totals

Re: PIVOT TABLE ISSUE

Tue, 04 Mar 2014 15:45:15 GMT

as you said you wanna use straight table. so you can hide/show columns.

Re: PIVOT TABLE ISSUE

Tue, 04 Mar 2014 15:51:07 GMT

you can use simple one time macro to hide column in pivot table

sub Hidecol

call Hidecolumn(''CH01'',1)

end sub

private sub Hidecolumn(ch,n)

set ch = activedocument.getsheetobject(ch)

ch.setpixwidth (n-1),0

end sub

Re: PIVOT TABLE ISSUE

Tue, 04 Mar 2014 18:18:22 GMT

Where Do I place this Sub Routine at ??

Re: PIVOT TABLE ISSUE

Tue, 04 Mar 2014 18:26:52 GMT

cntrl+ M gives you the macro editor , write this macro (make sure to use your chart number and hiding column number) and run it once.

Re: PIVOT TABLE ISSUE

Tue, 04 Mar 2014 19:51:46 GMT

Well I have to use the Straight Table, cuz I am using Mini Charts and I dont have an option of Mini Charts in PIVOT Table, How can I accomplish The Subtotals in Straight Table for a Group of Dimensions.