topic Re: Set Analysis and Growth Calculation in QlikView

Set Analysis and Growth Calculation

Wed, 25 Nov 2020 16:16:04 GMT

I have a calculation which is failing and need some help. I am trying to calculate growth using two set analysis values, but its not working.

The set analysis values are below:

Sum({$<[Account]={"40K"}, [Date]={"01/12/2016"}>}[Sales]) .....so lets say this equals $100

Sum({$<[Account]={"40K"}, [Date]={"01/11/2016"}>}[Sales]) ......and lets say this equals $90

A normal growth sum looks like Sum(100-90)/90 and this would equal 11.1%

The attempt below fails when I go to divide (Bold) what am I doing wrong?

Sum({$<[Account]={"40K"}, [Date]={"01/12/2016"}>}[Sales]) - Sum({$<[Account]={"40K"}, [Date]={"01/11/2016"}>}[Sales]) / Sum({$<[Account]={"40K"}, [Date]={"01/11/2016"}>}[Sales])

Re: Set Analysis and Growth Calculation

sunny_talwar — Thu, 19 Jan 2017 17:19:22 GMT

Try this:

(Sum({$<[Account]={"40K"}, [Date]={"01/12/2016"}>}[Sales]) - Sum({$<[Account]={"40K"}, [Date]={"01/11/2016"}>}[Sales])) / Sum({$<[Account]={"40K"}, [Date]={"01/11/2016"}>}[Sales])

or this

Sum({$<[Account]={"40K"}, [Date]={"01/12/2016"}>}[Sales])/Sum({$<[Account]={"40K"}, [Date]={"01/11/2016"}>}[Sales]) - 1

Re: Set Analysis and Growth Calculation

Thu, 19 Jan 2017 17:37:35 GMT

Thanks Sunny. This worked