1) I have a dataset that has last 2 quaters data for now (will have close to 6 - 8 quarters data in future) and would like to do a comparison depending on what user wants to look at i.e. there are 4 inputboxes that would allow user to compare data from any of the previous quarters. User can choose to enter either 2, 3 or all 4 input boxes for comparison. (THIS PART IS DONE - INPUT BOX CREATED AND CORRESPONDING VARIABLES HAVE ALS BEEN DEFINED WHERE THE VALUES ARE STORED AND WILL BE USED IN EXPRESSION LATER ON).
User Input Variables :
vCur_Val = 2014Q2
vPrev_Val1 = 2013Q4
vPrev_Val2 = 2013Q2
vPrev_Val3 = 2012Q4
2) The target report that is required to be published has a specific format which I am trying to replicate in QlikView Pivot structure.
Sample format of the traget report (Last column (Calculations) is not the part of actual report but to explain how the proportions are being calculated)
No Calculation for Proportion
CL/GL >> (CL as proportion on GL)
The report in qlikview till the amounts column has been created and amounts get populated for comparison based on user inputs.
Problem part in the project :
Next step is to create the proportions field where it is getting a bit tricky.
This is what I tried -
- Created variables to fetch the sum of each item to be used in expression later.