Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
coloful_architect
Creator II
Creator II

want to make line chart selectable after using set expression to filter out certain time frame

Hi masters:

I have a line chart with a 3 years range by months. From Jan 2018 to Dec 2020

rather than presenting all monthly of 3 years data, I only want to show 2 years.

so I created a variable for Jan 2019 as v_start  ( =Date(max({1}[Calendar Year/Month]-330),'MMM-YY'))

At my line chart expression for measure, I set 

=Sum({$<[Calendar Year/Month]={'>=$(=v_start)'}>}[Sales in Units])/1000

it works at my line chart to only show 2 years data. However, it locks the 2 years chart. so if I try to click one single month, I can not zoom into that particular month. 

Any way to filter out 12 months but still make 12 months clickable and selectable? 

ps: I do use $ set modifier to make it a responsible mode. but it only make selection interactive with other dashboard. For that line chart, it still blocks me from clicking single or selecting multiple months.

1 Solution

Accepted Solutions
Vegar
MVP
MVP

Try using a modifier with a *= notation, like this:

=Sum({$<[Calendar Year/Month]*={'>=$(=v_start)'}>}[Sales in Units])/1000

View solution in original post

1 Reply
Vegar
MVP
MVP

Try using a modifier with a *= notation, like this:

=Sum({$<[Calendar Year/Month]*={'>=$(=v_start)'}>}[Sales in Units])/1000