Calculation independent from selections

[Anonymous]

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

[stevedark]

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!

[sunny_talwar]

What is your performance expression? May be something like this in set analysis

{<Day = , Week = p(Week)>}

[Anonymous]

(count({$< [ArrivalDate] = > }if(AEMinsInDept<=240,'')))/count({$< [ArrivalDate] = > }INPATIENT_DATA_ID)

[sunny_talwar]

Try this

Count({$<[ArrivalDate], ArrivalWeek = p(ArrivalWeek), AEMinsInDept {'<=240'}>} INPATIENT_DATA_ID)/Count({$<[ArrivalDate], ArrivalWeek = p(ArrivalWeek)>} INPATIENT_DATA_ID)

[Anonymous]

This is the basic expression based on departure date

count(if(AEMinsInDept<=240,''))/count(INPATIENT_DATA_ID)

[sunny_talwar]

Try this:

Count({$<[ArrivalDate], ArrivalWeek = p(ArrivalWeek), AEMinsInDept {'<=240'}>} INPATIENT_DATA_ID)/Count({$<[ArrivalDate], ArrivalWeek = p(ArrivalWeek)>} INPATIENT_DATA_ID)

[Anonymous]

Unfortunately nothing is returned

[sunny_talwar]

Do you have a field called ArrivalWeek or something similar in your dashboard?

[Anonymous]

Only have arrival date and departure date fields