topic Re: Set Analysis (How can i compare a Month in 2014 with the same month in 2013, ex 2012, ex2011 etc) in QlikView

Set Analysis (How can i compare a Month in 2014 with the same month in 2013, ex 2012, ex2011 etc)

nico_ilog — Tue, 12 Aug 2014 14:47:19 GMT

Hi Community,

Im a slight NOOB when it comes to the Calendar.

How can i create chart that compares Each of the 12 Months in a Year, with the SAME months in all previous years?

It specifically pertains to comparing the count(Imported vehicles) of each month to the same month in other years?

Any pointers or help on where to start?

Regards,

Nico

Re: Set Analysis (How can i compare a Month in 2014 with the same month in 2013, ex 2012, ex2011 etc)

sebastiandperei — Tue, 12 Aug 2014 16:05:41 GMT

Suposing you have "Month" and "Year" fields. In a graph that contains "Month" as dimmention, you could use the following expression:

Count({<Year={2014}>} Distinct Imported_ID )/Count({<Year={2013}>} Distinct Imported_ID )-1

If it doesn't work, you should send a reduced copy of the qvw to see your data.

Re: Set Analysis (How can i compare a Month in 2014 with the same month in 2013, ex 2012, ex2011 etc)

nico_ilog — Tue, 12 Aug 2014 16:17:27 GMT

Thanx for the response.

I have gotten as far as to use the month field and then i created SET analysis expression as follows:

=count({1<Year = {2014}>} IM5_RegisterationNumber_Extension)

It does works and gives me a "not-toooo-bad" chart, but it feels slightly disapointing, because if i want the other YEARS to be included, i now need to go make create them in the Expressions for each Year... it spands back to '05.. lol

See below!

Please explain what is to be achieved with the code you provided? Why do you (divide) 2014 by 2013's count?

Re: Re: Set Analysis (How can i compare a Month in 2014 with the same month in 2013, ex 2012, ex2011 etc)

Tue, 12 Aug 2014 16:21:49 GMT

HI there,

I dont think you need set-analysis here as your dimensions are month and year. Please take a look at the example. I am not sure where you are facing a problem (may be I might be missing something here)

Re: Set Analysis (How can i compare a Month in 2014 with the same month in 2013, ex 2012, ex2011 etc)

sebastiandperei — Tue, 12 Aug 2014 16:24:31 GMT

I have supossed you need to show the "Growth" between these years.

I can't uderstand what you really need. Please, specify by another way.

Re: Set Analysis (How can i compare a Month in 2014 with the same month in 2013, ex 2012, ex2011 etc)

nico_ilog — Tue, 12 Aug 2014 16:45:47 GMT

Let me rephrase.

I want to achieve this:

Year	Jan	Feb	Mar	Apr	etc
2010	Total Count for Jan, in 2010
2011	Total Count for Jan, in 2011
2012	Total Count for Jan, in 2012
2013	Total Count for Jan, in 2013
2014	Total Count for Jan, in 2014

In a chart format.

Sorry for the confusion lads.

Re: Set Analysis (How can i compare a Month in 2014 with the same month in 2013, ex 2012, ex2011 etc)

sebastiandperei — Tue, 12 Aug 2014 17:19:06 GMT

I think Ajay example is what you need... Or not?