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

Variable dimensions

Hi, I need to refine a chart with variable dimensions:

Escalas.jpg

Attach file QV

Thank you so much!

1 Solution

Accepted Solutions
Sergey_Shuklin
Specialist
Specialist

Hi, Carlos!

I've tried to use class() function and then create a chart. Works fine:

class.png

But, if you define your intervals manual try to sort an axis with expression:

class2.png

Hope you find it usefull!

View solution in original post

5 Replies
Anil_Babu_Samineni

Can you elaborate more

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
Sergey_Shuklin
Specialist
Specialist

Hi, Carlos!

You can achieve this dimension refining using a Class() function.

It has such syntax class(expression, interval [ , label [ , offset ]]).

In your case it will be "=Class(Value,5)" and "=Class(Value,10)" calculated dimension expression respectively.

You also can use a variable instead of values (five and ten) and let a user to enter it in Input Box.

Hope it helps!

ahaahaaha
Partner - Master
Partner - Master

Hi Carlos,

May be like in attached file

Regards,

Andrey

cattaneoc
Contributor II
Contributor II
Author

Hello,

I can not represent X = 0 in the graph.

Imagen 1.jpg

The perfect graph would be with X = 0 in the center, with different colors for negative and positive (with a single dimension).

I know I ask a lot !!

Thank you

Sergey_Shuklin
Specialist
Specialist

Hi, Carlos!

I've tried to use class() function and then create a chart. Works fine:

class.png

But, if you define your intervals manual try to sort an axis with expression:

class2.png

Hope you find it usefull!