Set Analysis Monthly Totals and explains

Tue, 10 Mar 2015 15:43:43 GMT

Hi,

I'm rather new to qlikview and of course set analysis has a ton of quesitons, but I'm not sure if this is covered it doesn't seem to be. I have a bill month to month that I need to sum, and break down by product. Each month I need to sum the totals of all products and have a running total on what the month to month costs are, that part is easy. Now what I have to do is figure out how to identify what the differences are.

Here is an example:

20150101

serverA

itemA - $1000

itemB - $1200

SUM: $2200

20150202

serverA

itemA - $900

itemB - $1200

itemC - $800

serverB

itemA - $1100

SUM: $4000

I know I went up $1800 but I need to be able to show why and I think set analysis is the way to do it but I'm stuck on how to visualize and present that. Ideas are welcome!

Re: Set Analysis Monthly Totals and explains

NickHoff — Tue, 10 Mar 2015 18:52:06 GMT

Create a master calendar and link it to your fact data's date. Then you can do a set(s) Since you are doing a comparison, you'll want to add in an alternate state, then instead of the $ below you'll have the alternate state name.

=AGGR(SUM({$<Item={'itemA'}>}billamount),Item)

=AGGR(SUM({$<Item={'itemB'}>}billamount),Item)

=AGGR(SUM({$<Item={'itemC'}>}billamount),Item)

topic Set Analysis Monthly Totals and explains in QlikView

Set Analysis Monthly Totals and explains

Re: Set Analysis Monthly Totals and explains