Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Calculation independent from selections

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

12 Replies
stevedark
Partner Ambassador/MVP
Partner Ambassador/MVP

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
Not applicable
Author

(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
Not applicable
Author

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
Not applicable
Author

Unfortunately nothing is returned

sunny_talwar

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

Anonymous
Not applicable
Author

Only have arrival date and departure date fields