Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Discover how organizations are unlocking new revenue streams: Watch here
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 (1)
0 Replies