Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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 (2)
1 Reply
Kushal_Chawda

Create a variable on frond end

vSelectedDate

=max(CalendarDate)

then use below expression

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