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: 
Not applicable

Analysis with Diagram

Hello everbody,

i have the following problem:

My data is sorted into different orders which contain various binary attributes.

qv orders.bmp

I want to display the data in a graphic which shows the corrleations of single attributes to other single attributes.

The size of the Bubble should be a measurement for correlation. The problem is, that i have the same axe in one diagram twice.

qv Forum 2.bmp

I tried it with the Matrixdiagram and the Pointdiagram.

The Problem of the Pointdiagram is that its axes are  formulas and I am not able to categorize to the specific attributes.

The Pointdiagram looks pretty fine, but im not able to insert the same dimension twice.

It would be very nice if you can give me any hints or tipps or just the side of the manual

Down is displayed the logic for the correlation:

qv forum 1.bmp

11 Replies
swuehl
MVP
MVP

Sodele,

=if(SACode<>SACode5,

count(aggr(NODISTINCT if(ProdNummer=%ProdNummer5,1),ProdNummer,%ProdNummer5)) / count(ProdNummer)

)

Not applicable
Author

Thank you very much for your fast answers Stefan 😃