Issue with Set Analysis Expression Resulting in Blank Column

[yh2023]

Hello everyone,

I am currently facing an issue with a set analysis expression in Qlik Sense, and I would appreciate any insights or assistance.

I am attempting to use the following expression:

={<Appt_Date = >} if(Appt_Date1 >= date('$(vMaxApptDate)'), Count(distinct IPNO))

where the variable vMaxApptDate is defined as max(Appt_Date). The field Appt_Date is present in the date range filter.

However, the result is a blank column.

Observations in the Chart Expression:

 

[Anil_Babu_Samineni · Accepted solution]

@yh2023 Perhaps the syntax like this

Count({<Appt_Date=, Appt_Date1={">=$(=vMaxApptDate)"}>} distinct IPNO)

[hic]

Anil's solution should work. The reason why can be found here:

https://community.qlik.com/t5/Design/Use-Aggregation-Functions/ba-p/1475833