Qlik Community

Qlik Sense App Development

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

Not applicable

Get Selected Count

I have a chart that by default looks to a rolling 13 month time frame,but can be updated if the user selects a different date frame from a filter pane.

The code in the chart looks like the following:

if(GetSelectedCount(SurgeryMonthYear)>0,

count({<ORCaseVolumeFlag={1}>} LOG_ID)

,count({<SurgeryDate={"$(= '>=' & FirstDayMonthRolling12 & '<=' & LastDayMonthRolling12)"},ORCaseVolumeFlag={1}>} LOG_ID))

On a different sheet with different logic, I need the date to be updated based off a date filter as well. When I select a date outside of the rolling 13 months, no data is present.

This is the logic I have in the sheet not working as I'd like it to.

Count({<

Holiday={'N'},

Weekend={'N'},

FirstCaseInRange={'Y'},

LocationName={'DCH OR'},

AddOnCase={'N'},

ScheduledTime={"<=08:30:00 AM"},

SurgeryDate={"$(= '>=' & FirstDayMonthRolling12 & '<=' & LastDayMonthRolling12)"},

LateStartYN={'N'}

>}

Distinct LOG_ID)

/

Count({<

Holiday={'N'},

Weekend={'N'},

FirstCaseInRange={'Y'},

LocationName={'DCH OR'},

AddOnCase={'N'},

ScheduledTime={"<=08:30:00 AM"},

SurgeryDate={"$(= '>=' & FirstDayMonthRolling12 & '<=' & LastDayMonthRolling12)"}

>}

Distinct LOG_ID)

I know I need to add the GetSelectedCount somewhere in this expression, but every time I add it how I believe it should be, my data goes away.

Hoping someone can help me figure out how to make this work. Thanks in advance.

Community Browser