Skip to main content
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
Showing results for 
Search instead for 
Did you mean: 

expression value listbox changes when one is selected

I have a table with the fields year, weeknumber, enddate week

I have a variablevmaxyear

In my listbox field weeknumber can be selected and an expression is added : =sum(distinct {<year= {$(vmaxyear)}>enddate_week)

When no selecttion is made, the enddates are correct presented. When a weeknumber is selected however, the date of the selected weeknumber is presented correctly, but all the other dates give 30-12-1899.I can explain why , but I would like to keep the correct dates presented. Is that possible ?

SOLVED: changed the expression to : =sum(distinct { weeknumber=, <year= {$(vmaxyear)}>enddate_week)



0 Replies