Qlik Connectors Discussions

Discussion Board for collaboration regarding Qlik Connectors.

New Contributor III

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
MVP

Re: Calculation independent from selections

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!

MVP

Re: Calculation independent from selections

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

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

New Contributor III

Re: Calculation independent from selections

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

MVP

Re: Calculation independent from selections

Try this

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

New Contributor III

Re: Calculation independent from selections

This is the basic expression based on departure date

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

MVP

Re: Calculation independent from selections

Try this:

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

New Contributor III

Re: Calculation independent from selections

Unfortunately nothing is returned

MVP

Re: Calculation independent from selections

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

New Contributor III

Re: Calculation independent from selections

Only have arrival date and departure date fields