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

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
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