Skip to main content

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

An issue has been identified on Qlik Cloud hub, please visit our Status Update Page for details: GET THE LATEST
Showing results for 
Search instead for 
Did you mean: 
Contributor III
Contributor III

Date filter aplay less than or equal

Hello Guys , am new to qlik

I have Date field "Date_NEW"  i use it in filter pane , i want to retreive all dates less than or equal filter pane value 
so when user select date  .. the dashboards dimention and measure should run before or equal that date

for example  if he select  30-11-2020  the table should get the max date by  15/11/2020 and latest status Active.




Latest status =If(aggr(nodistinct max({<Date_New={ "<=$(v_MAX)"} >}Date_New),OBJNR) = Date_New, TXT30)

MAX_DATE=aggr(max({<Date_New={ "<=$(v_MAX)"} >}Date_New),OBJNR)

Labels (1)
0 Replies