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

Need to display latest year data whenever the selections on year list box is cleared

Dear All,

I have a requirement to display the current year data whenever the selection on "Year" list box is cleared.

i.e; if the current selection on Year list box is 2019,2020. On selecting clear All, 2021 data needs to be displayed.

I added a variable with below expression and applied Select in Field Trigger as below

variable --> If(GetSelectedCount(Year)=0,max(Year),GetFieldSelections(Year))

Trigger --> Field - Year, value - max(Year)

with this the latest year data is getting displayed whenever the clear all is selected but user also wanted to make multiple year selection.

Both of these requirements are not working at the same time. So, requesting your inputs on this at the earliest.

Labels (2)
0 Replies