topic Re: Set Analysis, or I think so in App Development

Set Analysis, or I think so

Anonymous — Tue, 06 Feb 2018 17:05:05 GMT

Hi. I work with Qlik Sense. I need to get a list of customers who bought an X product.

That X product is the most sold in the current year.

To obtain it, I used the function "firstsortedvalue (ProductName, -Ventas)" that returns the product with the highest sales value.

It shows it in a KPI and it is with respect to the selected year, if a year has not been selected then it obtains by default the one of the most recent year.

I already verified that and in effect I obtain the product with the most sales (money, not volume by quantity).

But now I have to show a table with exclusively the customers that bought that product and their purchase amount.

I have as Dimension: Clients

I have as Measure: sum (sales)

Re: Set Analysis, or I think so

sunny_talwar — Tue, 06 Feb 2018 17:25:01 GMT

May be this

Sum({<ProductName = {"$(=FirstSortedValue(ProductName, -Ventas))"}>}sales)

Re: Set Analysis, or I think so

Anonymous — Tue, 06 Feb 2018 17:51:03 GMT

Excellent, Thanks. Keep in touch

Re: Set Analysis, or I think so

Anonymous — Tue, 06 Feb 2018 18:05:07 GMT

I would like them to be seen from the most recent year. Because, by default it shows all the costumers who have bought during all these years, from 2004 to 2009.

Re: Set Analysis, or I think so

sunny_talwar — Tue, 06 Feb 2018 18:06:22 GMT

May be this

Sum({<ProductName = {"$(=FirstSortedValue(ProductName, -Ventas))"}, Year = {"$(=Max(Year))"}>}sales)

Re: Set Analysis, or I think so

Anonymous — Tue, 06 Feb 2018 18:08:56 GMT

Excellent. Thank you Sunny

Re: Set Analysis, or I think so

Anonymous — Tue, 06 Feb 2018 20:09:51 GMT

I will have to do that. I'm trying do a comparison of products, where I need to find my most sold product that wasn't sell the previous year.

Re: Set Analysis, or I think so

sunny_talwar — Tue, 06 Feb 2018 20:12:59 GMT

May be this

Sum({<ProductName = {"$(=FirstSortedValue({<ProductName = e({<Year = {$(=Max(Year) - 1)}>})>}ProductName, -Ventas))"}, Year = {"$(=Max(Year))"}>}sales)