topic Re: Change field parameter in Scatter chart without changing the field in QlikView

Change field parameter in Scatter chart without changing the field

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

Hello,

How can I change the x-axis parameter value, without changing the content of the field, but only in order to choose a value with fewer decimals to be considered in the scatter chart.

The scatter chart quickly finds all combinations between my x and y parameters, but the x-parameter has a numerical value with 2 decimals, and I only want to compare the values with 1 decimal in the scatter chart instead, without effecting all the other selections including the field itself. How can I do that?

Re: Change field parameter in Scatter chart without changing the field

Anil_Babu_Samineni — Wed, 13 Sep 2017 05:47:42 GMT

Can you help us to understand the query and please highlight the one where we are looking?

Re: Change field parameter in Scatter chart without changing the field

wardzynski — Wed, 13 Sep 2017 09:36:33 GMT

Anil,

There are 2 type of parameters, let us call them risk and potential gain.

The risk parameter in the scatter chart uses 2 decimals, i.e. 2.34, 2.45, 2.56, etc... the other parameter is an integer.
Now I want to see all possible results based on a more narrow set of possibilities where the risk parameter uses only 1 decimal and not 2, i.e. 2.3, 2.4, 2.6, etc...
Then the expression would not be able to use as many possible values for the risk parameter, because it has only 10 possible values between each 1 integer value instead of 100 possibilities. As an example:
Risk 2.2 x n (potential gian), 2.3 x n (potential gain), 2.4 x n (potential gian), etc... instead of 2.21 x n (potential gain), 2.22 x n (potential gain), etc....

I basically want to narrow down the possible outcomes by limiting the risk parameter into bigger chunks.

I would also want to try to change the risk parameter to even bigger steps like:
2.0, 2.5, 3.0, 3.5, 4.0 instead of 2.1, 2.2, 2.3, 2.4 or as it is now 2.01, 2.02, 2.03, 2.04, 2.05, 2.06, etc etc etc...

Hope this is clearer?

Re: Change field parameter in Scatter chart without changing the field

Anil_Babu_Samineni — Wed, 13 Sep 2017 09:53:27 GMT

What does "n" indicates which as "potential". And i feel you are expecting scale concept. I would ask you to check over Axes tab for X-axis

Re: Change field parameter in Scatter chart without changing the field

wardzynski — Thu, 14 Sep 2017 00:59:48 GMT

I can not activate these settings for some reason.

Re: Change field parameter in Scatter chart without changing the field

wardzynski — Thu, 14 Sep 2017 01:06:07 GMT

Anil,

>What does "n" indicates which as "potential". And i feel you are expecting scale concept.

On the x-axis I am using a risk parameter that has to many possibilities, due to the decimal factor. I want to limit the amount of possible potential values (n), by limiting the steps. I think you are on the right track with the x-axis static step idea, but its a bit unfortunate that it is not working atm.

Re: Change field parameter in Scatter chart without changing the field

Anil_Babu_Samineni — Thu, 14 Sep 2017 02:45:32 GMT

How many dimensions and expressions you have? To enable Scale options it should be 2 dims/expressions required

Re: Change field parameter in Scatter chart without changing the field

rwunderlich — Thu, 14 Sep 2017 03:08:35 GMT

=Round(Risk, .1)

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

Re: Change field parameter in Scatter chart without changing the field

wardzynski — Thu, 14 Sep 2017 03:52:56 GMT

2 dims, 1 expression (for the bubble size)

Re: Change field parameter in Scatter chart without changing the field

wardzynski — Thu, 14 Sep 2017 03:59:44 GMT

Hi Rob,

This was the solution to what I thought was my initial problem, thanks Rob.

But I now see that it is not entirely the solution to what I want to achieve:

I have 3 parameters, each one of them deals with an intervall of values.

Maximum Risk.
Minimum Parameter1.

Minimum Parameter2.

When I limit the amount of possibilities to changing Risk to 2 decimals, I get indeed fewer possibilities, but only for instances of all 3 parameters, and not with the interval ranges. What I mean by this is that the optimal solution only works for when Risk is exactly 3.5 and not >3.5, same applies to Parameter1 and Parameter2.
Is there any intelligent way to show the sum(calculation) for these 3 parameters including an entire set of their values and not just a point value?

Let me know if I need to explain a bit better.

Re: Change field parameter in Scatter chart without changing the field

Anil_Babu_Samineni — Thu, 14 Sep 2017 04:07:17 GMT

Will you please provide sample

Re: Change field parameter in Scatter chart without changing the field

dinuwanbr — Thu, 14 Sep 2017 08:53:36 GMT

Hi,

Can you provide a sample?

Rgds,

Dinu1

Re: Change field parameter in Scatter chart without changing the field

rwunderlich — Thu, 14 Sep 2017 17:14:28 GMT

I think we need to see some examples including the expressions you are currently using.

-Rob

Re: Change field parameter in Scatter chart without changing the field

wardzynski — Fri, 15 Sep 2017 00:16:44 GMT

Here are 3 screenshots for the scatter chart that I initially wanted to post.
Rob: The rounding really helped, thank you, but it does not fully solve my problem yet.

This scatter chart below shows different results (expression: sum(Profit)), for only an instance of my parameters Type9 and Type11. What I really want is the results inside the scatter chart for intervals, such that the result will represent the sum(Profit) for maximum Type7 (Risk) and minimum Type11.

For instance: I want to see the result (sum(Profit)) if I would select max Type7 (y-axis, Risk) value of 22 (including all values below 22). And the same for Type11, I want to get the sum(Profit) for all combinations of minimum 10 and above.

Maybe this is logically not even possible using a scatter chart.

I have also a third parameter that I have not included yet, but I was hoping there was a way to solve this. Maybe I can represent intervals on the y- and x-axis instead of singular values, such as that a value of 20 on the y-axis (Type7, Risk), actually represents the entire range of values from 0 to 20, instead of just the value of 20.

I think you should understand me by now. The values are straight forward: 1,2,2,3,4.. for each parameter and the sum(Profit) is the simplest expression. Maybe I am not using the correct chart type?!?