Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
simonagheo
Contributor III
Contributor III

Year comparison for expressions

Hello,

I have a pivot table with many expressions that are vertically arranged and a month dimension. I want to make a comparison with the same month last year, plus a quarter sum and I don't know how to do this for all expressions.

Now I have:

  

-Jan FebMarApr
Expression 1
Expression 2
Expression 3
Expression 4
Expression 5

And I want to obtain:

  

-Jan 2016Jan 2015Jan %Feb 2016Feb 2015Feb %Mar 2016Mar 2015 Mar %Q1 2016Q1 2015Q1 %
Expression 1
Expression 2
Expression 3
Expression 4
Expression 5

Any ideas?

Thank you!

3 Replies
Not applicable

You can user alternate states for your situation.

  Easy for me to say , can you upload qvw?

 

 

simonagheo
Contributor III
Contributor III
Author

I made a simplified sample with just one table and some expressions. Actually there are many other expressions and columns. Can you help me to compare every epression with the same expression last year?

Not applicable

I have created seperate calendar date data in excel spreadsheet which has  two years (2015&2016) data.

Attached qvw & excel.

I have left months format as was uploaded.

Capture.PNG