topic Re: Compare two charts with different calendar in QlikView

Compare two charts with different calendar

Tue, 03 Jul 2012 08:41:40 GMT

Hi all.

I would like to create a tab where I have two straight tables and for each table there should be a calendar so I could compare those tables within different date periods. I have attached a excel to show how it could be visualized.

Is there anyone that have any suggestions how to solve this?

Thanks in advance!

Re: Compare two charts with different calendar

vincent_ardiet — Tue, 03 Jul 2012 10:10:28 GMT

Hi,

Have you had a look to the the alternate state functionality ?

It seems to offer something close to your need.

Regards,

Vincent

Re: Compare two charts with different calendar

Tue, 03 Jul 2012 11:21:11 GMT

Do you have any example?

Re: Compare two charts with different calendar

vincent_ardiet — Tue, 03 Jul 2012 12:18:21 GMT

Are you familiar with Alternate states ?

If it's not the case, have a look to the help page in Qlikview (Alternates states and Examples of Alternates states).

Else, with the help of alternate states, you can have a single calendar table in your datamodel. You have to create an alternate state (document properties), for example called "State1".

Then, you create in double your listboxes for year, month and quarter and you assigned State1 to a year, a month and a quarter listboxes.

After that, you can make comparisons in your expressions with something like this :

sum([Nr Cust]) - sum( {$<[Year] = p({State1} [Year]), [Quarter] = p({State1} [Quarter]), [Month] = p({State1} [Month])>} [Nr Cust])

Regards,

Vincent

Re: Compare two charts with different calendar

Tue, 03 Jul 2012 12:22:08 GMT

Hello larsbjorn,

As Vincent suggests, alternate states is a very useful tool för this. Setting two different alternate states and assigning chart 1 to state A and chart 2 to state B will allow you to make selections in the calender (with different states) that only affects one of the charts.

This way you can make date selections in calender 1 and results will show in chart 1. At the same time you can make selections in calender 2 and results will show in chart 2 for comparison.

Alternate states are found under Document properties -> General -> Alternate states

Hope that was what you were looking for. Good luck!

Re: Compare two charts with different calendar

Wed, 04 Jul 2012 08:44:28 GMT

Hello.

I guess this function is only possible in version 11? I can't find it and I'm using version 10. Is there a way to do similar things in version 10?

Re: Compare two charts with different calendar

vincent_ardiet — Thu, 05 Jul 2012 12:29:25 GMT

Hi,

Yes you're right, it's a new functionality in version 11.

In version 10, may be you can duplicate in your datamodel your calendar (with other column names using QUALIFY for example) but keeping the same KEY in order to join your fact tables with the two calendars.

Then, you can have listboxes coming from the two calendars.

And, in your expression (if your second calendar is called Calendar2), you can use Set Analysis like that (not tested) :

sum({$<[Calendar2.Year] = , [Calendar2.Quarter] = , [Calendar2.Month] = >}[Nr Cust]) - sum({$<[Year] = , [Quarter] = , [Month] = >}[Nr Cust])

Regards,

Vincent

Re: Compare two charts with different calendar

Wed, 18 Jul 2012 12:59:32 GMT

Hi,

Maybe you can use set analisis, set and set in your different table the year, no ?

Regards Fabien