topic Re: Pivot Table Help in QlikView

Pivot Table Help

Fri, 03 Aug 2012 08:54:16 GMT

Hi All,

I am new to qlikview and have a few questions about pivot table layout. See attached.

1. How to i add a summary column at the end for all the quarters?

2. What is the best way to hide the blank column?

3. how do i auto expand everything and remove the expand icon?

Thanks for you help.

Kevin

yvesqlik — Fri, 03 Aug 2012 09:06:10 GMT

1. Click Properties->Presentation, choice the dimesion and click of 'show partial sums'

2. In the same property, you can choice, how you want to show the missing value 'missing symbol'

3 and finally alway in the same property, with 'always fully expanded' your problem will be solved.

Anonymous — Fri, 03 Aug 2012 09:09:31 GMT

Hi Kevin,

Please provide some sample data.. So we can try a work around for you.

Fri, 03 Aug 2012 09:23:39 GMT

Hi,

I have just attached the data.

Thanks,

Kevin

buzzy996 — Fri, 03 Aug 2012 09:25:39 GMT

hi kevin,

u can follow "yvesqlik" description,tht's the solution.