Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
sujit_nath
Creator II
Creator II

Difference in pivot table

I have a pivot table with one expression, sum(sales) and multiple dimensions. The data looks like -(posting dummy data)

Capture.PNG

I want to calculate the difference in Q1 and Q2 and show it as a column beside this.

How should I achieve this.

4 Replies
Arthur_Fong
Partner
Partner

What if there's Q1,Q2,and Q3?

 

sujit_nath
Creator II
Creator II
Author

No, It's a dummy data I've shown. It's like 2 values are there.

the data I need to see should be like:

Capture.PNG

The red colored data is what I am struggling with.

Arthur_Fong
Partner
Partner

Is your Quarter dimension going to have 2 values only?

I mean there is 4 quarters in a full year, which means in your Quarter column there will be  Q1,Q2,Q3, and Q4.

How are you going to get the difference between each quarter?

sujit_nath
Creator II
Creator II
Author

Hi Arthur,

Yes, I will have only 2 values there. As said, this is dummy data as I can not show actual data due to restrictions etc. The value of quarters may change, line for 2019 it may be Q1 and Q2, but for 2018, it may be Q3 and Q4. So, I'll need to show the difference in both the quarters under the year. (Please ignore the relevancy of the data)