Help KPIs and Dimension

[educastri83]

Hello! I need to solve this that a client poses to me.

It is required to visualize a KPI that identifies what and how many are the possible kind of products that exist when a specific product is sold, for example the product DA.

I would like to include a dimension that shows 2 options:

1) show the existing kind of products when I sell the DA product;

2) those not then not applicable.

Maybe with AGRR ?? I'm just a rookie in qlik.

Thank you very much

[educastri83]

Maybe stalwar1‌‌ can you solve it?

[sunny_talwar]

I will take a look at it

[sunny_talwar]

I would like to include a dimension that shows 2 options:

1) show the existing kind of products when I sell the DA product;

2) those not then not applicable.

For 1, do you mean to show what all products are sold when to Client (Code Client) when a client buys DA or is this more at a transaction level? In a particular transaction what all product sell together?

[educastri83]

Something like.. show me all kinds of products that exist or are sold to clients when a client buys the DA product. They do not necessarily have to be sold together.

[sunny_talwar]

The left chart only shows top 5 clients, do you need the products sold to only top 5 clients or all clients? For all, you can use this

=Count({<[Clase de documento], Cuenta = p(Cuenta)>}[Documento compras])

[educastri83]

It works! thanks

I'll really need for all clients, Although the intention of the chart is to show the top 5.

Although the intention of the grafic is to show the top 5.

If I would like to include a new list box that shows me all products that have been sold to clients who have purchased the DA product, what should I do?, Maybe like this

[sunny_talwar · Accepted solution]

Would you be making selections in that list box? Because since DA is already selected, it will show something like this

But any further selections in this, it will change the list.

List box expression used

=Aggr(Only({1<Cuenta = p(Cuenta)>} [Clase de documento]), [Clase de documento])

[educastri83]

Perfect, it works.

Yes, I'll be making selections in the list box.

Now if the last thing I lack .. In case the DA product has not been selected ?, I would like a permanent list box to return the products that have been sold to clients who have purchased DA

The product "DA" is the most important for the company, Therebefore the need to have the possibility to select in a list box the other products sold when also sold DA.

Sunny, thanks! I really appreciate your support in this moment

[sunny_talwar]

Try this

=Aggr(Only({1<Cuenta = p({1<[Clase de documento] = {'DA'}>}Cuenta)>} [Clase de documento]), [Clase de documento])