topic Re: script help in Budget Report in QlikView

script help in Budget Report

Wed, 15 May 2013 10:02:53 GMT

Hi,

i got a budget report for forecast vs actual revenue billed by year & by month.

In that report, when user selects a month which is less than current month, one column should show the actual revenue, otherwise forecast amount.

And when user selects multiple months, same logic should be applied by summing up.

please help me to achieve this.

Thanks.

sushil353 — Wed, 15 May 2013 10:15:55 GMT

you can acheive this using conditional show in expression. in your expression check the condition checkbox..

there you can put condition like =if(getfieldselections(month)=vPreviousmonth,1,0)

calculate the previous month variable...

HTH

Sushil

Thu, 16 May 2013 00:30:00 GMT

Hi Sushil,

thanks for your help.

but, we got the fiscal calendar which is 1st July - 30th June.

so, how can I calculate the previous month variable?

i tried below logic, but didn't go well.

IF(GetFieldSelections([Fiscal Month])<month(today()),[Billed Revenue],Forecast)

probably , need to create Inline table to get Fiscal Month Number?