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.

Announcements
An issue has been identified on Qlik Cloud hub, please visit our Status Update Page for details: GET THE LATEST
cancel
Showing results for 
Search instead for 
Did you mean: 
Zahmed14
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.

 

exampl.JPG 


VMAX=MAX(DATE_NEW)

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