topic Re: Variable dimensions in QlikView

Variable dimensions

cattaneoc — Wed, 25 Nov 2020 16:16:04 GMT

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

Attach file QV

Thank you so much!

Anil_Babu_Samineni — Wed, 10 May 2017 03:33:39 GMT

Can you elaborate more

Sergey_Shuklin — Wed, 10 May 2017 05:11:39 GMT

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 — Wed, 10 May 2017 14:29:48 GMT

Hi Carlos,

May be like in attached file

Regards,

Andrey

cattaneoc — Wed, 10 May 2017 15:21:47 GMT

Hello,

I can not represent X = 0 in the graph.

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 — Wed, 10 May 2017 17:24:18 GMT

Hi, Carlos!

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

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

Hope you find it usefull!