Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
jmialoundama
Specialist
Specialist

Display dates less than or equal to the chosen date

I have a filter pane in which I have a DATE FOR GL dimension, this dimension only contains dates.

 

1.JPG

I have a table in which I call this dimension.
When the user filters on a date, I would like to display all the dates less than or equal to this date.

For example, if the user selects the date of 07/12/2019, I would like to display in my table all the dates before or equal to 07/12/2019

Labels (3)
3 Replies
Qlik1_User1
Specialist
Specialist

Try this

Count({<dateforgl= {"<=$(=GetFieldSelection(DATE(dateforgl,'MM/DD/YYYY'))"}> } AnyDimension)

jmialoundama
Specialist
Specialist
Author

I try , but i have this error : 

 

Capture.JPG

Qlik1_User1
Specialist
Specialist

Please share the complete expression.