Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.

Visualization and Usability

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details

Who Me Too'd this solution

Kushal_Chawda

Create a filter pan with below expression

=aggr(only({<Year = {">=$(=year(today())-1)<=$(=year(today())+1)"}>}Year),Year)

 

then create a variable  vYear at front end with below expression

=if(GetSelectedCount(Year)=0,year(today()),max(Year))

 

then you can use below expression in your chart to restrict it default to current year ..based on filter selection it will change.

Count( DISTINCT {$<Year={"$(vYear)"}>}id)

View solution in original post

Who Me Too'd this solution