topic Re: Help KPIs and Dimension in QlikView

Help KPIs and Dimension

educastri83 — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Help KPIs and Dimension

educastri83 — Fri, 16 Jun 2017 11:55:38 GMT

Maybe stalwar1‌‌ can you solve it?

Re: Help KPIs and Dimension

sunny_talwar — Fri, 16 Jun 2017 12:00:24 GMT

I will take a look at it

Re: Help KPIs and Dimension

sunny_talwar — Fri, 16 Jun 2017 12:14:52 GMT

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?

Re: Help KPIs and Dimension

educastri83 — Fri, 16 Jun 2017 12:48:31 GMT

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.

Re: Help KPIs and Dimension

sunny_talwar — Fri, 16 Jun 2017 14:03:11 GMT

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])

Re: Help KPIs and Dimension

educastri83 — Fri, 16 Jun 2017 15:16:21 GMT

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

Re: Help KPIs and Dimension

sunny_talwar — Fri, 16 Jun 2017 15:20:50 GMT

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])

Re: Help KPIs and Dimension

educastri83 — Fri, 16 Jun 2017 15:42:16 GMT

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

Re: Help KPIs and Dimension

sunny_talwar — Fri, 16 Jun 2017 15:46:00 GMT

Try this

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

Re: Help KPIs and Dimension

educastri83 — Fri, 16 Jun 2017 15:52:21 GMT

That's it!!

You helped me a lot!

Re: Help KPIs and Dimension

sunny_talwar — Fri, 16 Jun 2017 15:53:32 GMT

I am glad I was able to help .

Best,

Sunny

Re: Help KPIs and Dimension

educastri83 — Thu, 28 Feb 2019 14:03:41 GMT

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?