Set Analysis Help Req

[hariprasadqv]

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.

[qlikmsg4u]

please provide some sample data

[Anonymous]

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

[hariprasadqv]

Month-Year          sales

Mar-2015          200

Mar-2014          150

If user selects Mar-2015 then i have to calculate

1-(150/200)

[sunny_talwar]

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