Discussion board where members can get started with QlikView.
I am trying to achieve a dynamic comparison between fields in a pivot table (quarter on quarter in this specific case).
I have tried to build a set analysis but, it did not work.
Please note that quarters (Q1, Q2, Q3 and Q4) are set with a mapping reading the date.
Below is my data with no calculated expression.
And following image should be the final result where the trend between current and previous quarter is shown.
Thank you for your help.
Go to Solution.
Thank you very much for the script.
It looks fantastic but unfortunately when adapted to my data (file not inline) it overstates the overall value and percentages (e.g. 518.709.020 instead of 269.599 for business 01).
Any reason why?
Thank you and kind regards,
Below the two pivot images not attached previously.
Lines of Business
Q3 vs Q2
It's without SetAnalysis. I have solve this with a calculation in script. See attached file.
Pleae upload sample application for reference.
Maybe you can use these solutions:
=sum(amount) / before( sum(amount) )
=column(ColumnNo()) / before( column(ColumnNo()) )