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: 
Not applicable

Month on Month Comparison

Just wondering if anyone can help me with a query that I am trying to solve.

What I have is a file that I attached as an example of the data I am working with but it is only a tiny sample of the size of the data I am using.

What I want to do is to be able to do a month on month comparison. So when I export to Excel I can look side by side and see how each company is performing month on month. As you can see some accounts can be new and this means the accounts are not side by side so with a large file I would have to manually align the data in Excel.

I was wondering is their anyway in Qlikview that I can align the data so I can simply export to Excel and have the Income for each account side by side. Maybe I can do it in a graph or someway.

I don't know if it is even possible but it would make my life a lot easier if it is so if anyone could help I would really appreciate it.

Regards,

Sue

1 Solution

Accepted Solutions
awhitfield
Partner
Partner

Hi Sue,

Create a pivot With Dimension: Company, Year Month and expression Sum(Income), it'll look like this initially:

Click on the + to expand Year then month

Click on the Month Column header and drag right (blue vertical arrow appears), drag it over Sum(Income)and release when the blue arrow is horizontal,

then drag the Year above the month etc.

HTH - Andy

View solution in original post

7 Replies
vardhancse
Specialist III
Specialist III

Hi,

In order to get that, we need to split the expression in to 2 things.

Some thing like for eg:

Exp_1: Sum({<Month={'Apr'}>}Cost)

Exp_2: Sum({<Month={'May'}>}Cost)


So that in the chart/table we can get 2 separate columns and we can compare easily.


If we want difference, we can get by (Sum({<Month={'Apr'}>}Cost))-(Sum({<Month={'May'}>}Cost))


Or else


simply column(1)-column(2)

awhitfield
Partner
Partner

Hi Sue,

would a pivot table suffice?

HTH- Andy

Not applicable
Author

Hi both would be very helpful but the pivot Table looks good.

I am only using the personal edition so I can't open any Qlikview documents.

Would you be able to post here what I would need to do to be able to get the data like that.

Thanks for your help.

ogster1974
Master II
Master II

You could visualise your comparisons a number of ways.  A few samples attached.

Pivot and Bar charts to get you going.  Note they will all export back to excel.

Regards

Andy

awhitfield
Partner
Partner

Hi Sue,

Create a pivot With Dimension: Company, Year Month and expression Sum(Income), it'll look like this initially:

Click on the + to expand Year then month

Click on the Month Column header and drag right (blue vertical arrow appears), drag it over Sum(Income)and release when the blue arrow is horizontal,

then drag the Year above the month etc.

HTH - Andy

View solution in original post

Not applicable
Author

Got it sorted.

Thanks again for all the reply's they were a great help.

awhitfield
Partner
Partner

Glad to be able to help!

Have a good day! 

Andy