Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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. 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.
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.
Hi Kevin,
Please provide some sample data.. So we can try a work around for you.
Hi,
I have just attached the data.
Thanks,
Kevin
hi kevin,
u can follow "yvesqlik" description,tht's the solution.