Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a dashboard with performance % for day selected but also want to include performance % for the whole week up to date selected.
Many thanks
Jess
Hi Jessica,
The short answer is; you need to use Set Analysis.
The longer answer will take a bit more time...
This app may help point you in the right direction:
QlikView App: Set Analysis - Prior Period Comparison
Note that where that app uses the MonthStart function, there is also a WeekStart function that you will want to use.
Also, a note of warning on gauges (if you are using those to show percentage), make sure you don't have a dimension set for them or this will give spurious results (only the value for the first sorted entry in that dimension).
Good luck!
What is your performance expression? May be something like this in set analysis
{<Day = , Week = p(Week)>}
(count({$< [ArrivalDate] = > }if(AEMinsInDept<=240,'')))/count({$< [ArrivalDate] = > }INPATIENT_DATA_ID)
Try this
Count({$<[ArrivalDate], ArrivalWeek = p(ArrivalWeek), AEMinsInDept {'<=240'}>} INPATIENT_DATA_ID)/Count({$<[ArrivalDate], ArrivalWeek = p(ArrivalWeek)>} INPATIENT_DATA_ID)
This is the basic expression based on departure date
count(if(AEMinsInDept<=240,''))/count(INPATIENT_DATA_ID)
Try this:
Count({$<[ArrivalDate], ArrivalWeek = p(ArrivalWeek), AEMinsInDept {'<=240'}>} INPATIENT_DATA_ID)/Count({$<[ArrivalDate], ArrivalWeek = p(ArrivalWeek)>} INPATIENT_DATA_ID)
Unfortunately nothing is returned
Do you have a field called ArrivalWeek or something similar in your dashboard?
Only have arrival date and departure date fields