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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Nemo1
Creator II
Creator II

How to represent a line chart with many dimensions without ending up with a chart that looks like a mess?

Hello, 

I need a piece of advice. 

I have like 9 dimensions and I want to represent the sum of sales in the course of time. 

However, if i represent that on a line chart it ends up looking awful... 

any suggestion? 

 

thanks!!

Labels (3)
1 Solution

Accepted Solutions
theoat
Partner - Specialist
Partner - Specialist

Yes it is possible.
Capture d'écran 2024-02-22 140310.png

To do this, sorts the measure to ascend the dimension in sort expressions.
Capture d'écran 2024-02-22 140317.png

Enjoy your Qlik.

Kind regards,
Théo ATRAGIE.

View solution in original post

7 Replies
theoat
Partner - Specialist
Partner - Specialist

Hello Nemo ! How are you ?

Maybe using the stacked areas?
Capture d'écran 2024-02-22 134035.png

Enjoy your Qlik.

Kind regards,
Théo ATRAGIE.

Nemo1
Creator II
Creator II
Author

is there a way to sort the dimensions according to their sales in your case? In the case that you are showing me, I would like to have for example Northeast closer to the X axis than Canada, because Canada has more sales...  thanks!!

theoat
Partner - Specialist
Partner - Specialist

Yes it is possible.
Capture d'écran 2024-02-22 140310.png

To do this, sorts the measure to ascend the dimension in sort expressions.
Capture d'écran 2024-02-22 140317.png

Enjoy your Qlik.

Kind regards,
Théo ATRAGIE.

Nemo1
Creator II
Creator II
Author

I get a message that says "You cannot change sorting when using a continous dimension axis" 😞 

theoat
Partner - Specialist
Partner - Specialist

Can you show me ?

Nemo1
Creator II
Creator II
Author

it did work out, merci! 

theoat
Partner - Specialist
Partner - Specialist

With pleasure Nemo.