Imp Expression

Mon, 17 Feb 2014 05:30:45 GMT

Hi,

I new to QV, Can Anybody help me to understand this expressions please...

1. if(Sum({$<Year={$(=Max(Year)), $(=Max(Year)-1)}, _History = {1}>} Sales/$(vCurrency)) > Sum({$<Year={$(=Max(Year)), $(=Max(Year)-1)}, _History = {1}>} Budget_$(vCurrency)), 1, -1)

2. if(Space <> 's', Sum ({<Year = {$(=Max(Year)-1)}, Month = {'<= $(=num(Month(vTodaysDate)))'}>}Actual * PL_Flag) + Sum({<Year = {$(=Max(Year)-1)}, Month = {$(=Month(vTodaysDate))}>}[Closing Amount] * BS_Flag),

thanks in advcance

Regards

Venu Gopal

Re: Imp Expression

jagan — Mon, 17 Feb 2014 05:51:07 GMT

Hi Venu,

If Sales for Current and Previous years are > Budget for Current and Previous years then 1, else -1 is returned.

If Space is not equal to 's',

then sum of Actual * PL_Flag for previous year till this month + sum of Closing Amount * BS_Flag of previous year current month.

Hope this helps you.

Regards,

Jagan.

topic Re: Imp Expression in QlikView

Imp Expression

Hi,

1. if(Sum({$<Year={$(=Max(Year)), $(=Max(Year)-1)}, _History = {1}>} Sales/$(vCurrency)) > Sum({$<Year={$(=Max(Year)), $(=Max(Year)-1)}, _History = {1}>} Budget_$(vCurrency)), 1, -1)

Re: Imp Expression