Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
nico_ilog
Partner - Creator II
Partner - Creator 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
Specialist
Specialist

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
Partner - Creator II
Partner - Creator II
Author

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

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
Specialist
Specialist

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
Partner - Creator II
Partner - Creator II
Author

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
Specialist
Specialist

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