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

madhudinesh — Fri, 15 Nov 2024 23:17:32 GMT

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.

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