topic Hiding Certain Columns for Pivot table Chart in QlikView

Hiding Certain Columns for Pivot table Chart

Sat, 07 Nov 2009 10:34:27 GMT

I have column groupings by month in a pivot table.

Lets say Jan, Feb, Mar all has columns A, B, C, D, E. and columns A and C are static data and never change

but B, D, E change by month

I would like to keep columns A, C as static columns and only display them once in the table together and rest of the columns for every month.

Can you guys suggest me some ideas to do this. I wrote a macro to hide the columns but that hides or displays columns for all months and not display them just once.

I even tried breaking the table into two and only show the two static columns in one and others in the other one but the tables together don't render correctly.

Any ideas are welcome

Thanks

Hiding Certain Columns for Pivot table Chart

Thu, 12 Nov 2009 05:58:24 GMT

Any Ideas??? (John, Oleg, Rakesh, Rob)

Hiding Certain Columns for Pivot table Chart

johnw — Thu, 12 Nov 2009 06:26:05 GMT

I'm actually not clear what you're asking. Can you show sample data and what you want your resulting chart to look like?

Hiding Certain Columns for Pivot table Chart

Anonymous — Thu, 12 Nov 2009 14:18:51 GMT

Hi Srikdave,

Are you talking about something like this?

			JAN			FEB
A	C	B	D	E	B	D	E
10	20	1	2	3	4	5	6
20	30	2	3	4	5	6	7

Where you place a few of the values outside the parent dimension Month?

Hiding Certain Columns for Pivot table Chart

Thu, 12 Nov 2009 14:33:15 GMT

John, Johannes,

Attached here is the snapshot of what I am looking for.

Johannes, Yes, A & C needs to stay in the table but just show once and the rest of the columns repeat for each month.

Thanks

Hiding Certain Columns for Pivot table Chart

Sat, 14 Nov 2009 03:18:24 GMT

As I saw in an other post, I am trying to have another inline dimension on top of the month to say if it is static or repeat by month.

Do you think that will work with dynamic expressions and dynamic dimensions???

I mean if my months are driven by the data???

Hiding Certain Columns for Pivot table Chart

Anonymous — Sun, 15 Nov 2009 04:35:35 GMT

Still not quite clear...
Maybe what you need is to use static columns A and C as dimensions, probably as calculated dimensions. One more dimension is month. Three expressions, B, D and E.