Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
In my current working file i am trying to place the value in at a particular degree location.
If i select value in a field i.e; AngleTabPos=90.0812334 , then in scatter chart in needs to plot that dot at 90degrees from centre 0.
Please the attached file.
How can i work on this ? And please can you help on this.
Thanks in advance.
Hi,
Change the order of the expressions in the char, i.e, make the second expression "RadialPos" as first expression.
Hope this helps you.
Regards,
Jagan.
Hi ,
I tried it, but Its not working.
Is there any other way to work on it.
Thanks
Hi Ravi,
Check the attachment.
Regards,
Jagan.
HI ,
can you please explain what the below expression mean ?
If((Only ([AngleTabPos]) > 90 AND Only ([AngleTabPos]) <=180), Mod(Round(Only ([AngleTabPos])), 90),
If((Only ([AngleTabPos]) > 270 AND Only ([AngleTabPos]) <=360), Mod(Round(Only ([AngleTabPos])), 270) * -1,
If((Only ([AngleTabPos]) > 180 AND Only ([AngleTabPos]) <=270), Mod(Round(Only ([AngleTabPos])), 180) *-1, Only ([AngleTabPos]))))
Thanks
Hi,
Is this what you are expected? Is the graph is correct?
If AngleTabPos is between 90 and 180 then we need to show this in Top left and the value should be less than 90, so I taken the remainder by dividing it with 90.
Same way for 180 to 270, divinding with 180,
271 to 360 dividing with 270.
So, that always I will get a value below 90 degrees.
Regards,
Jagan.
Hi Jagan,
First thanks to you sharing your knowledge with me.
i didn't get exact result what i am trying to work from your attached file.
What i need is if i click any value in AngleTabPos , that value should plot as a dot and the dot should loacte at its degree values as seen in image.
Ex1: if i click AngleTabPos= 359.9502608980, then its value dot should plot at near to 360 degree shown in image
Ex2: if i click AngleTabPos= 270.0088420703, then its value dot should plot at near to 271degree shown in image
Ex3: if i click AngleTabPos= 90.012123503, then its value dot should plot at near to 91degree shown in image.
I hope you understood what i am trying to work.
Thanks
If AngleTabPos is the angle, what's the radius? Angle123Pos? Probably not, but just substitute in whatever you want as the radius, or don't do the multiplication at all if you don't care what the radius is, and are ONLY plotting an angle. Just use trigonometry:
x = Angle123Pos*cos(pi()*AngleTabPos/180)
y = Angle123Pos*sin(pi()*AngleTabPos/180)
For performance, I suggest computing these x and y values in your script. I couldn't do that in the example since I don't have your QVD. I'd probably use fixed axes based on the max radius, or possibly rangemax(max(ScriptX),max(ScriptY)), and you also need to make sure your charts are sized so that both axes have the same scale.
I may, of course, have misunderstood the question.
Hi John,
Thanks for your reply,
The Radius Field is the RadialPos,
From Your Expression i just replaced the Angle123Pos with RadialPos field. And in axis of X and Y replace with RadialPos field.
Before the image is in Anti-Clockwise Angles, but now i am trying to work in Clockwise Angles. What should i change in expression for clockwise Angles.
If any doubt please reply me, i will try to give more clearly.
Please see the modified attached qvw file.
Thanks in advance.
Heh, I'm responding to something you've removed from your post, but in case you're still wondering, and since I already had an example file, and since I think it's an interesting question that others may be curious about, I'll answer anyway. You'd asked, "Can we increase the dots size in diagram for only which are grouping or overlapping with other dots in 1 Pixel distance. And these Overlapped dots should have a different color from which are not overlapped dots."
Yes we can, but what is the purpose of the different color and size? If you're just trying to make denser regions stand out more, I think a better solution is to use an argb() color, so that multiple dots build up a stronger color. For instance, argb(100,0,0,0). You could also use a variable for the transparency, and have a slider or drop down selection for values. Sometimes different patterns are more obvious at different transparency values.
If you really do want to change the color and size of the points, you can do that, but if you have a lot of data points, it can get quite inefficient. Fortunately, that inefficiency can be moved to the script, but with enough data, it will eventually bog down too much to be practical. I don't know how much data you have, though. In any case, the attached example shows both script and chart versions of the idea.
You'll need a little modification to match your example. It's looking for clusters of at least five. For clusters of two, just change the 5 to 2 in the script and in the third chart expression of the chart that appears when you press the button. You'll also want a smaller cluster radius for your data (it's using 2.5, hidden as 6.25, the square of 2.5). If you want it to be a pixel, then figure out what a pixel corresponds to.