Qlik Community

Ask a Question

New to Qlik Sense

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

Announcements
Join us for a live Q&A! September 21, 10 AM ET - Onboarding Fast in Qlik Sense SaaS! REGISTER
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