Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Pivot Table Help

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

1 Solution

Accepted Solutions
yvesqlik
New Contributor III

Re: Pivot Table Help

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.

4 Replies
yvesqlik
New Contributor III

Re: Pivot Table Help

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.

rathodniky
Contributor

Re: Pivot Table Help

Hi Kevin,

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

Not applicable

Re: Pivot Table Help

Hi,

I have just attached the data.

Thanks,

Kevin

buzzy996
Honored Contributor II

Re: Pivot Table Help

hi kevin,

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

Community Browser