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

    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
          Nick Hoff

          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)