Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Associations with fields in a Pivot Table

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

1 Reply
adityaakshaya
Creator III
Creator III

Hi Alec,

Can you help me to understand you rproblem with dummy dataset so that I can provide some solution to you.

Regards,

Akshaya