Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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 (4)
1 Solution

Accepted Solutions
theoat
Partner - Creator III
Partner - Creator III

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

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

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

Can you show me ?

Nemo1
Creator II
Creator II
Author

it did work out, merci! 

theoat
Partner - Creator III
Partner - Creator III

With pleasure Nemo.