topic Re: Comparitive Analysis using Alernate State in QlikView

Comparitive Analysis using Alernate State

Fri, 03 Jul 2015 18:33:09 GMT

Hello QV users:

I would like to request your help on the attached QVW sample,

I am trying to compare combined May & Jun sales in 2014 ($100+200 = $300)

with individual Jan & Feb sales in 2015 $300 & $ 400

in the attached sample QVW I am looking to create a column like this:

I have created alternate states C & P for Current Year/Month & for Prior Year/Month respectively.

Any help would be greatly appreciated.

Kumar

Re: Comparitive Analysis using Alernate State

swuehl — Fri, 03 Jul 2015 18:48:19 GMT

Kumar,

maybe like attached?

Re: Comparitive Analysis using Alernate State

Fri, 03 Jul 2015 20:25:56 GMT

Hello Swuehl;

Many thanks for your reply and for your time, your solution was good, but when I applied to my main model I had an issue since I forgot in my sample to add product as a dimension. Would it be possible to relook into the sample for a desired result like following

Re: Comparitive Analysis using Alernate State

swuehl — Fri, 03 Jul 2015 21:29:03 GMT

That's not trivial.

I do have a solution, but it fails for the Prd where you don't have any records in State C.

Prd B will just not show up.

I assume this is also the case in your real data, or do you have data for each Prd (could be zero value)?

Re: Comparitive Analysis using Alernate State

Fri, 03 Jul 2015 22:50:41 GMT

Hello Swuehl;

The data structure for actual purpose has values in both the states P & C , my example was again bad,

there will not be a case like Prd B

Sorry for the inconvenience,

Kumar

Re: Comparitive Analysis using Alernate State

swuehl — Fri, 03 Jul 2015 23:09:44 GMT

Ok, I've added the missing records in the INLINE LOAD.

Re: Comparitive Analysis using Alernate State

Sat, 04 Jul 2015 00:17:31 GMT

thanks very much Swuhel, appreciate the help