Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
cmehat123
New Contributor

Actual vs Target

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. .

Actual.JPG

can anyone please advise how I should handle this ??

Message was edited by: Hat p

1 Solution

Accepted Solutions

Re: Actual vs Target

Check if attached is what you wanted?

View solution in original post

4 Replies

Re: Actual vs Target

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?

cmehat123
New Contributor

Re: Actual vs Target

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

Check if attached is what you wanted?

View solution in original post

cmehat123
New Contributor

Re: Actual vs Target

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