right join and outer join not working to compare activities with customers vs whole universe of customers

[ceuribe]

Hi, I am analysing the data from our customers and I dont get to put together the analysis to compare the activies we have done with the customers vs. the universe of customers, even if I try to join the data by different joins:

I want to see if a customer has X,Y,W product in customer a,b,c... But we have a pool of N customers.

The automatic join is not working for me, unfortunately, even I tried to rename and add double values of the key ID.

I would like to see something like:

Product / Universe / # Costumers / Sucessful ratio

X          /        N       /  n                 / (n/N)

I tried to make an ourter join, a right join and auto connect the values, but nothing seems to work.

[Kushal_Chawda]

@ceuribe  Please share sample data with expected output

[ceuribe]

The data is like this (left side) and I want something like this (right side).

The problem is that I should do a cross table giving each customer all the values for all the products so I can count them, is there a way to give all the customers all the values of all the products and then make a flag if something was activated, is that possible?

[Kushal_Chawda]

@ceuribe  may be you can concatenate your data set. Please see the below link

https://help.qlik.com/en-US/qlikview/May2024/Subsystems/Client/Content/QV_QlikView/Scripting/ScriptP...

[ceuribe]

Hi! I tried that too, it did not work, but the cross join (join with no logical connection, seems to work, the only problem is that the data load is inmense, NxM is just too big and I am not sure if there is a way to optimize it.

[Kushal_Chawda]

@ceuribe  If you can share sample data in excel with expected output, I will try to build optimised script