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: 
Not applicable

Display monthly chart line until certain month

Hi,

I'm displaying a monthly chart, (Dimensions = month, Expressions=sum of price), which showing from January to December.

If the user input ReportMonth = May, the lineA should display from January - April values only while other lines still displaying till December.

How should i do this?

1 Solution

Accepted Solutions
tresesco
MVP
MVP

you have to take the input into a variable and then you have to use set analysis in the SUM expression to say that month<$Variable.

Hope this helps.

Thanks.

View solution in original post

1 Reply
tresesco
MVP
MVP

you have to take the input into a variable and then you have to use set analysis in the SUM expression to say that month<$Variable.

Hope this helps.

Thanks.