topic Set Analysis Help Req in QlikView

Set Analysis Help Req

hariprasadqv — Thu, 06 Aug 2015 10:56:58 GMT

Hi All,

I have a scenario in which user selects Month-Year(Mar-2015) in MothYear field.then i have to claculate growth of sales accordingly w.r.t Last year(Mar-2014) sales.

Ex: 1-(Mar-2014(sales))/(Mar-2015(Sales))

How can I do that.

Thanks In Advance.

Re: Set Analysis Help Req

qlikmsg4u — Thu, 06 Aug 2015 11:00:37 GMT

please provide some sample data

Re: Set Analysis Help Req

Anonymous — Thu, 06 Aug 2015 11:19:39 GMT

use set Analysis in Expression

= 1-(sum({<yourdatefield={'=$(=addmonths(yourdatefield-12))'}>}Sales)/sum(Sales))

/sum(sales) need not be enhanced by set Analysis as user selects march 2015 and therefor sum(sales) gets exactly that sum

Re: Set Analysis Help Req

hariprasadqv — Thu, 06 Aug 2015 11:23:13 GMT

Month-Year sales

Mar-2015 200

Mar-2014 150

If user selects Mar-2015 then i have to calculate

1-(150/200)

Re: Set Analysis Help Req

sunny_talwar — Thu, 06 Aug 2015 11:40:12 GMT

Are you calculating this in a chart or a text box object??? If its in a text box object, you should be able to do what Rudolf Linder‌ suggested. If its in a chart where date is a dimension then you would need to use above function.

HTH

Best,

Sunny