topic Re: How do i calculate the variable in expression in QlikView

How do i calculate the variable in expression

Tue, 10 Jul 2012 10:00:52 GMT

Dear All,

How do i calculate the variable in previous year.

Eg:

Vbsc = sum(if(billunit=3,Qty))* sum(if(billunit=5,Rate))

if i use the variable in following condition, its not working.

Current year = sum({$<year={$(=max(year))}>}Vbsc) - its working

Previous = sum({$<year={$(=max(year))}>}Vbsc) - not working

Can any one help me.

Regards,

Antony.

jvitantonio — Tue, 10 Jul 2012 10:15:52 GMT

Hi,

I don't see any differences between current and previous year. Anyway, try this:

Previous = sum({$<year={$(=max(year))-1}>}Vbsc) - not working

Tue, 10 Jul 2012 10:19:05 GMT

Hi,

Problem not in my condition, problem in variable.

variable is not giving the correct output for previous year, its showing my current year output in previous year.

jvitantonio — Tue, 10 Jul 2012 10:23:48 GMT

The problem is your expression because you are summing the same year. Add a -1 to the variable.

Tue, 10 Jul 2012 11:13:39 GMT

Hi ,

Thanks for your reply...

Can u tel me how ?? i did not understand...

MayilVahanan — Tue, 10 Jul 2012 12:39:08 GMT

Hi,

Suppose you have year such as 2008,2009,2010,2011,2012

=Max(Year) gives 2012

=max(Year)-1 gives 2011

So,

= sum({$<year={$(=max(year)-1)}>}Vbsc) give result for previous year

Hope it helps