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

Announcements
Independent validation for trusted, AI-ready data integration. See why IDC named Qlik a Leader: Read the Excerpt!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

dynamic number of lines in a chart

Hi!

I need to achieve something like this using qlikview.

error loading image

I want to select several years, nevermind the way I select them but I want, when I select One year, to print one Line matching the selected year, when I select two years, two lines... If that can help there are 5 years.

Even if what I am trying is not possible I will appreciate any advice to get a similar result.

Thanx to all.

2 Replies
johnw
Champion III
Champion III

You need to have a Year field and a Month field, where the Month field isn't a date, just a month, like month(MyDate) as Month. Then just put the Year and Month fields as your first and second dimensions. It will then show one line per year selected.

Not applicable
Author

Thanx John. That is exactelly What I need.