Qlik Community

Qlik Sense App Development

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

Highlighted
ebrahimaljafri
New Contributor II

count from current day and prior 7 days

hi qlik 

 

i have request to achieve count of Appointment beside on user selection from max date and 7 days prior also 

count of Appointment  from  7 days prior to 14 days prior 

 

my set analysis is as following :

count ({<MASTER_DATE={">=$(=max(MASTER_DATE_PRIOR_7))<=$(=max(MASTER_DATE))"}>} appointment_appt_code)

 

please help

 

1 Reply
uacg0009
Valued Contributor

Re: count from current day and prior 7 days

Hi,

If the date field that user selected is "MASTER_DATE", please try to use below expression, it works in my desktop:

count ({<MASTER_DATE={"<=$(=date(max(MASTER_DATE)))>=$(=date(max(MASTER_DATE)-7))"}>} appointment_appt_code)

Please make sure the format of  date(max(MASTER_DATE)) is same with MASTER_DATE, 

if not, please use date() to adjust it.

Please try.

Aiolos Zhao

Community Browser