Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Support Case Portal has moved to Qlik Community! Read the FAQs to start exploring Support resources.
cancel
Showing results for 
Search instead for 
Did you mean: 
dreweezy
Partner
Partner

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
Partner
Partner

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