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

Announcements
Save $650 on Qlik Connect, Dec 1 - 7, our lowest price of the year. Register with code CYBERWEEK: Register
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