Skip to main content
Announcements
See why Qlik was named a Leader in the 2024 Gartner® Magic Quadrant™ for Data Integration Tools for the ninth year in a row: Get the report
cancel
Showing results for 
Search instead for 
Did you mean: 
mrbqlik2009
Contributor III
Contributor III

pick voucher dates less thank selected date from calendar

Hi,

I have calendar contain year, month and day. and bellow that have table that for showing vouchers. each voucher has date.

I want when i selected one date from calendar, show all vouchers dates less than selected.

 

Labels (1)
1 Reply
Kushal_Chawda

Create a variable on frond end

vSelectedDate

=max(CalendarDate)

then use below expression

=sum({<CalendarDate={"<$(vSelectedDate)"}>}Value)