Qlik Community

Qlik Sense App Development

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

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Highlighted
Partner
Partner

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
Highlighted
Partner
Partner

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