Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

nico_ilog
Contributor II

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

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

6 Replies
sebastiandperei
Valued Contributor

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

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.

nico_ilog
Contributor II

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

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!

Capture.JPG

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

Not applicable

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

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)

sebastiandperei
Valued Contributor

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

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.

nico_ilog
Contributor II

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

Let me rephrase.

I want to achieve this:

YearJanFebMarApretc
2010Total Count for Jan, in 2010
2011Total Count for Jan, in 2011
2012Total Count for Jan, in 2012
2013Total Count for Jan, in 2013
2014Total Count for Jan, in 2014

In a chart format.

Sorry for the confusion lads.

sebastiandperei
Valued Contributor

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

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

Community Browser