Qlik Community

Ask a Question

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements
Talk to Experts Tuesday, January 26th at 10AM EST: Qlik Sense. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Contributor II
Contributor II

Interaction between elements of a column (count of possibilities)

Hi! My first question here!

I have a table with 2 coluns, PERSON and PRODUCT (A, B or C).

 

PERSON PRODUCT
Person1 A
Person1 B
Person2 A
Person2 C
Person3 A
Person4 B
Person5 A
Person5 B
Person5 C
Person6 B
Person7 C
Person8 A
Person9 B
Person9 C
Person10 C
Person11 C

 

I want to count how often product interactions occur.

The count of this example above will look like this:

 

Interaction Count
A           1 (only A)
AB          1 (only A and B)
ABC         1 (only A and B and C)
AC          1 (only A and C)
B           2 (only B)
BC          1 (only B and C)
C           3 (only C)

 

Could you help me with this solution?

 

Thank you very much friends

Labels (3)
1 Solution

Accepted Solutions
Contributor II
Contributor II

Perfect Lockematthewp, good job!

But I could do it without using Load, directly in the dimension. Here's the solution (using your "concat" idea):

In dimension: "=Aggr( Concat(distinct PRODUCT,'') , PERSON)"

In expression: "=Count(DISTINCT PERSON)"

DimensionDimensionExpressionExpression

 

And with selection, we have this:

selection.png

 

Once again, thank you very much for your help!

View solution in original post

6 Replies
Creator II
Creator II

I solved it but I had to create a few more fields (isA, isAB, etc.) I then used set analysis to count if isA = 1, … I am attaching an example to show you.

Contributor II
Contributor II

Thanks for the attention friend, but it doesn't solve my problem ...

I need the solution to have no duplicity of situations ... For example, Person1 can only be in "AB", not in other possibilities.

Imagine a Veen Diagram (using the table I showed above):

 

VEEN.png

Thank you again!

Creator II
Creator II

Problem solved. And in a much better way.

P.S. There were two people that had A only not one.

Contributor II
Contributor II

Great solution! But you did it "on load time".

I wanted to see if it is possible to do "at selection time", ie ... that this table would be assembled according to the application selections ... For example, if I select only products A and B, it would only bring A, B and AB ...

"On load time" would be a viable but not perfect solution for me ...

Even so, thank you very much for the idea!

 

PS: people that had A = 2 really... 😉

Creator II
Creator II

Got it. 😁

I have two charts on top of each other with only one showing at a time. One for when no product selections are made and one where there was a selection. Try using the Product Listbox to choose. Let me know what you think.

Contributor II
Contributor II

Perfect Lockematthewp, good job!

But I could do it without using Load, directly in the dimension. Here's the solution (using your "concat" idea):

In dimension: "=Aggr( Concat(distinct PRODUCT,'') , PERSON)"

In expression: "=Count(DISTINCT PERSON)"

DimensionDimensionExpressionExpression

 

And with selection, we have this:

selection.png

 

Once again, thank you very much for your help!

View solution in original post