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: 
wardzynski
Creator
Creator

Change field parameter in Scatter chart without changing the field

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?

13 Replies
Anil_Babu_Samineni

Will you please provide sample

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
dinuwanbr
Creator III
Creator III

Hi,

Can you provide a sample?

Rgds,

Dinu1

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

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

-Rob

wardzynski
Creator
Creator
Author

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

DanielP_2017Sep14_8.30.22 AM_0000.pngDanielP_2017Sep14_8.30.29 AM_0001.pngDanielP_2017Sep14_8.32.11 AM_0003.png