topic Set help for YTD by month in QlikView

Set help for YTD by month

Fri, 17 Feb 2012 13:28:46 GMT

Hi,

I want to store sum of the selected months YTD value into variable and take the avg.

for example,

if i select feb,mar,

ytd for feb is 100

Ytd for mar is 120

then i need to show the value(variable) is (100+120)/2(no.of selected months)=>220/2=110

the problem i am facing is i dont know how to take the YTD for the selected months.

I can take the YTD for the max month. using <=max(month) in set.

if they select more than one month then i dont know how to do.

could anyone help me.

thanks in advance.

CELAMBARASAN — Fri, 17 Feb 2012 13:32:35 GMT

Hi,

You mean like this?

variable value is =Sum(value)/GetSelectedCount(Month)

Celambarasan

Anonymous — Fri, 17 Feb 2012 13:41:39 GMT

Your varialbe name = sum(value) / count(monthfieldname)

Regards

Ashok

Sat, 18 Feb 2012 05:08:33 GMT

thanks for ur reply.

thats is not i want.

I want to calculate the YTD. not sum(value)

thanks and regards,

Gopinathan L

deepakk — Sat, 18 Feb 2012 06:22:25 GMT

hi gopi,

try this application.

Deepak