Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
educastri83
Creator
Creator

Help KPIs and Dimension

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

12 Replies
educastri83
Creator
Creator
Author

That's it!! 

You helped me a lot!

sunny_talwar

I am glad I was able to help .

Best,

Sunny

educastri83
Creator
Creator
Author

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?