Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

calculate angle

Hai,

Can we calculate angle between two fields from data source.

Thanks

12 Replies
swuehl
MVP
MVP

I am not sure if I understand, what do you mean with angle?

You could use the common set of trigonometric functions, if that's what you are after.

Maybe it would be helpful if you post a small sample and your expected result.

Regards,

Stefan

Not applicable
Author

Hi Swuehl, Thanks for your response.

i am working on one project there  i am having a fields of AngleTabPos, and RadialPos.

Example consider the Lense(Circular shape) , suppose these 2 fields values are spotted on Lens then i needs to find the angle between them.

pls see the attached qvw file.

If any question please let me know , i will try to explain in better way.

Thanks

swuehl
MVP
MVP

As I understand you need both AngleTabPos and RadialPos to describe one defect location in polar coordinates.

So you won't calculate an angle between these two value, will you?

Do you want to calculate something between different defects? Since you already have the AngleTabPos, this should not be too complicated or do you need to use a different coordinate system here?

It would really be helpful if you could break it down to the most simple example, maybe only two defect, their locations and the expected outcome.

Not applicable
Author

Hi,

Should calculate angle between defect and AngleTabPos. And that angle should display as spot in concentration diagram.

Thanks

swuehl
MVP
MVP

As I understand, each record describes one defect. For some defects, there is no location in polar coordinates given (for example Defect.Bubble.Single or Lens.Missing).

Many defects already have locations set using AngleTabPos and RadialPos.

This is how I read your data.

What I don't understand is:

"angle between defect and AngleTabPos"

defect is no single field in your data. As I said, AngleTabPos is one attribute of what I would call a defect (record). If the location (AngleTabPos, RadialPos) are not given, how should we tell the location (and then - maybe we could go on calculating an angle between to items).

As I see, AngleTabPos and RadialPos are coming from your qvd, so what should we do if they are missing?

Not applicable
Author

Hi ,

Defect is nothing but "DefectName field".

Please see the example figure in word document.

Thanks

swuehl
MVP
MVP

Sorry, that's still a mystery too me.

"If DefectName is“Defect.Debris” and its coordinate value of “AngleTabPos” is 140.4291728368,then in Clockwise we need to calculate its angle between both of the fieldvalues."

I don't understand "both of the fieldvalues" here. I checked if I get always two values per Lenskey or ID, but that's not true. Please clarify.

Not applicable
Author

Hi Swuehl,

Sorry for not providing clear information to you.

But i will get back to you with full pledged details on this and i will reply to you as soon as possible. 

Thanks for sharing your knowledge and time with me.

Thank you very much.

Not applicable
Author

Hi ,

Can we rename the labels of each Trellis diagram in scatter chart.

i.e; Labels of each Trellis looks like 3/1, 4/1, 5/1 and so on but i am trying to change them as 1,2,3, and so on..

And how can i change the Horizontal slider to Vertical slider position in scatter chart (NOTE: I am using Trellis(both primary and secondary)).

Please see the attached file.


Thanks in advance.