I am using a Line chat with a toggle button so show Count and Value.
![kaushi2020_0-1695211535572.png kaushi2020_0-1695211535572.png](https://community.qlik.com/t5/image/serverpage/image-id/116657i0FAC8371D9EC5F9B/image-dimensions/777x160?v=v2)
in my expression, I am passing a date range from >= 1st of the month <= Current day -1. but if you see here in this, the data for 20th and rest of the day as 0 when I am using below expression. How we can customize so that it show data till 19th (Current Date : 20th Sept 2023) ?
if(GetFieldSelections(Data)='Count',
Sum({<Year=, Month=,Date=,Channel={'APP'},Date={">=$(=date(monthstart(max(Date))))<=$(=date(max(Date)-1))"}>}Count),
if(GetFieldSelections(Data)='Value',
Sum({<Year=, Month=,Date=,Channel={'APP'},Date={">=$(=date(monthstart(max(Date))))<=$(=date(max(Date)-1))"}>}Value)))