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: 
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!