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
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
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?

1 Solution

Accepted Solutions
Vegar
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
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.
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
Partner
Partner

Try this

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

Plees ekskuse my Swenglish and or Norweglish spelling misstakes

View solution in original post

Di
Contributor
Contributor
Author

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