topic Actual vs Target in QlikView

Actual vs Target

Anonymous — Sun, 25 Feb 2018 03:20:11 GMT

Hi,

I just need to calculate Actual vs Target by department wise. For Ex: If i select 2018 , I have sales for Jan, feb but for remaining months i need to put the previous month sales to know if we go with this sales trend whether we will meet the target. .

can anyone please advise how I should handle this ??

Message was edited by: Hat p

Re: Actual vs Target

sunny_talwar — Mon, 26 Feb 2018 13:05:29 GMT

You want to do this in the script or front end? Also, would you be able to provide the raw data to test this out?

Re: Actual vs Target

Anonymous — Thu, 01 Mar 2018 02:01:58 GMT

HI Sunny,

Please find the attached sample data. Here , i have sales for all the months in 2017 except aug 2017 but for 2018 i have till feb - I need to put the feb 2018 data for all the remaining month in 2018. it' can be either in script or front end.

Thanks for your response.

Re: Actual vs Target

sunny_talwar — Thu, 01 Mar 2018 18:28:04 GMT

Check if attached is what you wanted?

Re: Actual vs Target

Anonymous — Fri, 02 Mar 2018 02:50:32 GMT

Thanks Sunny. Really helpful and got some experience from you..