topic Month on Month Comparison in QlikView

Month on Month Comparison

Tue, 28 Jul 2015 08:39:02 GMT

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

Re: Month on Month Comparison

vardhancse — Tue, 28 Jul 2015 08:46:58 GMT

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)

Re: Month on Month Comparison

awhitfield — Tue, 28 Jul 2015 08:50:29 GMT

Hi Sue,

would a pivot table suffice?

HTH- Andy

Re: Month on Month Comparison

Tue, 28 Jul 2015 09:00:58 GMT

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.

Re: Month on Month Comparison

ogster1974 — Tue, 28 Jul 2015 09:02:30 GMT

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

Re: Month on Month Comparison

awhitfield — Tue, 28 Jul 2015 09:22:57 GMT

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

Re: Month on Month Comparison

Tue, 28 Jul 2015 09:40:07 GMT

Got it sorted.

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

Re: Month on Month Comparison

awhitfield — Tue, 28 Jul 2015 09:41:57 GMT

Glad to be able to help!

Have a good day!

Andy