Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator III
Creator III

Set analysis: ignore, but don't ignore

This may be simpler than I think... I have a straight table that displays patient names and several measures about their blood pressure (latest date, number of readings, etc.). Users can filter the date range of when blood pressure readings were taken.

I need to display the total count of blood pressure readings each patient has ever had. So it needs to ignore user selection on the date so that it counts all-time readings, BUT I want the table to honor the user selection so that it displays only patients who had (at least) a reading in the date range.

Using this measure causes the table to ignore the user selection altogether of course:

Count({<BPdate= >} BProwID)

As a result, the table is confusing because the user has applied a filter that is not being honored.

How can I get each patient's lifetime count while limiting the table to patients with the user-selected BPdate?

Labels (1)
1 Solution

Accepted Solutions
Highlighted

Re: Set analysis: ignore, but don't ignore

Try this

Count({<BPdate, Patients = p(Patients)>} BProwID)

View solution in original post

3 Replies
Highlighted

Re: Set analysis: ignore, but don't ignore

Try this

Count({<BPdate, Patients = p(Patients)>} BProwID)

View solution in original post

Highlighted
Creator III
Creator III

Re: Set analysis: ignore, but don't ignore

That works perfectly! Thank you for your instant response, Sunny!

Highlighted
Partner
Partner

Re: Set analysis: ignore, but don't ignore

Use GetSelectedCount on the date fields to identify if a selection has been made. if no selection has been made

Count( BProwID)

else something like

Count({<BPdate={"<=$(=YOURMAXDATE)>=$(=YOURMINDATE)"} >} BProwID)

if you can give specifics on the columns can help further