Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Di
Contributor
Contributor

Chart not responding to selection

Hi, for a line chart, I have included the following in the measures to limit the chart areas to years 2015 to 2019:

Avg({<[Year]={">=2015<2020"}>}Vacancy)

However, when selecting specific years (e.g. 2017-2019) on storyboard, the chart does not seem to respond to the selection. Any help on this?

Labels (3)
1 Solution

Accepted Solutions
Vegar
MVP
MVP

Try this

Avg({<[Year] *={">=2015<2020"}>}Vacancy)

View solution in original post

4 Replies
PrashantSangle

Hi,

It is because you hard coded that value. you can create your set analysis more dynamic

try below

Avg({<[Year]={">=$(=min(Year))<$(=max(Year))"}>}Vacancy)

 

Regards,

Prashant Sangle

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
Di
Contributor
Contributor
Author

Hi, thanks for the prompt response! But this displays all the values though (year 2002 to 2020). My original expression allows me to display only year 2015 to 2019 on the chart, but only issue is that it's not responding to selections in storyboard. Any alternatives?

Vegar
MVP
MVP

Try this

Avg({<[Year] *={">=2015<2020"}>}Vacancy)

Di
Contributor
Contributor
Author

That's great, it's working perfectly now! Thanks!!