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: 
dreweezy
Partner - Creator II
Partner - Creator II

Creating a line chart using multiple dimensions (using date fields)

I am trying to create a line / bubble chart to create a line chart based on how long each department took to approve for a given account. The problem I am seeing is I cannot bring in 5 different department dates into my chart as it discombobulates the logic. I have attached my app and a .png of what I am trying to achieve. I hope it makes much more sense. If you have any thoughts on how to go about this, would love to hear you guys thinking.

 

Thanks!

capture123.PNG

2 Replies
rogerpegler
Creator II
Creator II

I would change the underlying data model into a table that has a row per account and department with a third column for the number of days.

pedrobergo
Employee
Employee

Hi,

You need to unpivoting the table, moving the coluns to lines.

Enter in the script editor and Sees the script that do that to you.

Pedro