Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Welcome to our newly redesigned Qlik Community! Read our blog to learn about all the new updates: READ BLOG and REPORTED ISSUES
cancel
Showing results for 
Search instead for 
Did you mean: 
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?

1 Solution

Accepted Solutions
Partner
Partner

Try this

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

Plees ekskuse my Swenglish and or Norweglish spelling misstakes

View solution in original post

4 Replies

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.
Contributor
Contributor

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?

Partner
Partner

Try this

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

Plees ekskuse my Swenglish and or Norweglish spelling misstakes

View solution in original post

Contributor
Contributor

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