1 Reply Latest reply: Mar 10, 2015 4:28 PM by Nick Hoff

# Set Analysis Monthly Totals and explains

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

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)