Pivot Table Help

[#1]

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 · Accepted solution]

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]

Hi Kevin,

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

[#4]

Hi,

I have just attached the data.

Thanks,

Kevin

[buzzy996]

hi kevin,

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