Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content
Announcements
March 26 at 10am ET: See how Qlik drives growth and value in ISV segment - REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
madhudinesh
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 (1)
0 Replies