topic Re: Targets Mapping?? in QlikView

Targets Mapping??

rohitians — Fri, 15 Nov 2013 04:53:31 GMT

Hello Everyone,

I have sales dashboard, the master calender is mapped on sales date...

but i am making a target report where in targets till march 2014 is der...but i aint able to take whole of target for analysis..

it takes up to as on today n not fro dec13 to mar 14...how do i tackle this problem....

Thanks and Regards.

Rohit Yadav

Re: Targets Mapping??

Fri, 15 Nov 2013 05:00:42 GMT

Hi Rohit,

Can you please mention here what you write in script?

Thanks,

Ashutosh

Re: Targets Mapping??

rohitians — Fri, 15 Nov 2013 05:11:16 GMT

SUM({$<FinancialYear=,MonthName=,Quarter=,FiscalYear={$(=max(FiscalYear))}

,[Posting Date]={">=$(=MonthStart(max({$<FiscalYear={$(=max(FiscalYear))}>}[Posting Date])))<=$(=max({$<FiscalYear={$(=max(FiscalYear))}>}[Posting Date]))"}

>}[Monthly Tar Val])/100000

this is for monthly....

if i take sum([Monthly Tar Val])/100000 den i am not getting whole of 2013-14 target..

Re: Targets Mapping??

er_mohit — Fri, 15 Nov 2013 05:11:16 GMT

you also make a master calendar for target report and mapped to target report and concatenate it to sales master calendar

Re: Targets Mapping??

kaushiknsolanki — Fri, 15 Nov 2013 06:12:44 GMT

Hi,

Why dont you create a master calender fill the year of target and then link it to the sales data as well as target data.

Regards,

Kaushik Solanki