Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
Zahmed14
Contributor III
Contributor III

calculate the based on date filter pane selection

Hello Guys ,

I have a date filed "date_New"  i use in my filter pane  i need all results of my report  to be calculated by less than or equal this date .

Zahmed14_2-1610948927283.png

My dimension is  : =If(aggr(nodistinct max({<Date_New={ "<=$(v_MAX)"} >}Date_New),OBJNR) = Date_New, TXT30)

My measure is : Count( {< Date_New={ "<=$(v_MAX)"} > } OBJNR)

 

 

Labels (2)
0 Replies