Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am new to Qlik View and am having trouble with my pivot table I am creating. The Pivot table currently which am working is anticipated to have 4 columns(Store name, Month, actual Sales for that month and Projected Sales for that month. The problem I am having is getting the projected sales column to correctly correlate with the Store name and its month. I have fields Q1 Q2 Q3 Q4 projected sales with the correct numbers in them correlating to the correct store number. I need to know how to associated the number in Q1 in with the months 1,2,3 and so on for Q2, Q3 and Q4. Currently they are associated with the correct store but I need to figure out how to match them up with the correct month too
Hi Alec,
Can you help me to understand you rproblem with dummy dataset so that I can provide some solution to you.
Regards,
Akshaya