Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
lomi89
Contributor III
Contributor III

Line chart- Create Maximum line

Hello,

I would like to know if it possible to create a Maximum line when there are two dimensions as picture:

lomi89_0-1672241850117.png

The line should be dynamic depends on the filters.

 

Thank you very much.

 

Labels (5)
1 Solution

Accepted Solutions
Taoufiq_Zarra

@lomi89 if i understood correctly

in reference line

Taoufiq_Zarra_0-1672256697896.png

in reference line you can use the max() expression like :

Taoufiq_Zarra_1-1672256772687.png

 like this example :

Taoufiq_Zarra_2-1672256984887.png

 

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉

View solution in original post

2 Replies
Taoufiq_Zarra

@lomi89 if i understood correctly

in reference line

Taoufiq_Zarra_0-1672256697896.png

in reference line you can use the max() expression like :

Taoufiq_Zarra_1-1672256772687.png

 like this example :

Taoufiq_Zarra_2-1672256984887.png

 

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉
lomi89
Contributor III
Contributor III
Author

Hello,

The measure is sum(costs) and there two dimensions (line and group). When I don't want to filter, the max line is not correctly and depends on the filters, also, it is not perfect.

Are there any solution?

Thank you.