Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Discuss and learn more about Qlik Sense app development and usage.
Hi,
I have a SQL table with Column Names Date,Program,Cases
PROGRAM | date | CASES |
A | 4-Sept-19 | 3 |
A | 7-Sept-19 | 1 |
A | 8-Sept-19 | 1 |
A | 9-Sept-19 | 2 |
C | 1-Sept-19 | 2 |
C | 7-Sept-19 | 1 |
B | 4-Sept-19 | 1 |
B | 10-Sept-19 | 1 |
D | 5-Sept-19 | 1 |
D | 6-Sept-19 | 1 |
D | 12-Sept-19 | 1 |
E | 15-Sept-19 | 1 |
E | 18-Sept-19 | 1 |
This table is updated daily.
I have Yearly targets for each Program. Also if required I can calculate the business working days for each month. Even Monthly
Next what I want to implement in my dashboard is using the Yearly Targets and the business working days, how can I calculate the Daily or Weekly Targets or Monthly(Currently I have monthly calculated manually and feeding it) for each Program?
I am not asking for a code but a procedure how to go about it would be helpful
Thanks