Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
cmehat123
Contributor
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
sunny_talwar

Check if attached is what you wanted?

View solution in original post

4 Replies
sunny_talwar

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
Contributor
Contributor
Author

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.

sunny_talwar

Check if attached is what you wanted?

View solution in original post

cmehat123
Contributor
Contributor
Author

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