Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
alejortizp
Contributor III
Contributor III

Sum all the previous values since the date

Hi guys,

I am trying to select a date and when select that date sum all the previous values since the date i had chosen.

Thanks for all.

1 Solution

Accepted Solutions
JaMajka1
Partner Ambassador
Partner Ambassador

Hi Alejandro,


You could define variable v_date_filter = GetFieldSelections(date_field) and then use it in expression of KPI with set analysis:


sum({$<date_new={'<=$(v_date_filter)'}>}value)


Hope it helps ,

Maria

View solution in original post

1 Reply
JaMajka1
Partner Ambassador
Partner Ambassador

Hi Alejandro,


You could define variable v_date_filter = GetFieldSelections(date_field) and then use it in expression of KPI with set analysis:


sum({$<date_new={'<=$(v_date_filter)'}>}value)


Hope it helps ,

Maria