topic Re: Comparative Analysis in QlikView

Comparative Analysis

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

See attached.

I'm trying to compare Reasons from one Year to another as seen in the attached. I also would like to be able to compare months. How would I go about doing this?

Re: Comparative Analysis

nagarjuna_kotha — Mon, 20 Jun 2016 17:02:37 GMT

Like this ?

Let me know in case if u face any issue....

-Nagarjun

Re: Comparative Analysis

nagarjuna_kotha — Mon, 20 Jun 2016 17:03:13 GMT

u can create same for months also.........

-Nagarjun

Re: Comparative Analysis

Anonymous — Mon, 20 Jun 2016 17:07:32 GMT

No. What I attached is an example and prefer the formatting to be similar to what I have. I have 30 diffrent Reason codes and data starting from 2012.

Re: Comparative Analysis

nagarjuna_kotha — Mon, 20 Jun 2016 17:10:00 GMT

This is another type of approch...

-Nagarjun

Re: Comparative Analysis

Anonymous — Mon, 20 Jun 2016 17:26:43 GMT

That's better. But how would one link the YearMonth to the chart to allow counts. I was thinking something like this in my expression where I can filter on Months too.

Count({[AltState1]<Year = {2016}>}ID) Instead of adding Year change to YearMonth wildcard = 2016

Count({[AltState2]<Year = {2015}>}ID) Instead of adding Year change to YearMonth wildcard = 2015

Re: Comparative Analysis

nagarjuna_kotha — Mon, 20 Jun 2016 17:34:40 GMT

OKay....Like this ?

In this example year sections will not allow and rest will effect on charts as per ur selections.