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]

That's it!! 

You helped me a lot!

[sunny_talwar]

I am glad I was able to help .

Best,

Sunny

[educastri83]

Hi Sunny!
I open this old thread, for something that came back to cross my path…

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

served me for a list box of those who have bought a product from the "DA" document class, but I would like to have a list box for those who have exclusively bought "DA" and "ZV" as can I solve it?