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

Announcements
Qlik Connect 2026 Agenda Now Available: Explore Sessions
cancel
Showing results for 
Search instead for 
Did you mean: 
qurbanolum
Contributor
Contributor

Amount up to the lower limit of the selected date

How to choose the amount up to the lower limit? That is, I chose the lower time limit, for example, the first of April 2020. I need to print the sum of all dates that are below this lower bound i.e {beginning of the year} to {lower time limit}. I tried doing this 

Sum({<SOURCE={'FMBDP_SUM_PERC_B'}, Date={'<=$(=Date(min(Date)))'}>} SUM)

but it didnt work.

Labels (1)
0 Replies