topic Re: Column in set analysis in QlikView

Column in set analysis

Anonymous — Wed, 14 Sep 2016 12:15:12 GMT

Hello,

I'm from Brazil and I do not speak English , I'm using google translator to send this message . I'm having trouble using a value that is in another column set analysis , the Mx column I have the Year Month the last sale for each customer and product, I needed to return the sum of sales for each customer and product according to the year month in this column mx , I've tried a number of ways but I can not make that calculation , I have read that would have to use a sum ( if ( ) ) but it does not know how to do this in this case. Anyone know how to solve ess problem?

The file is attached .

Re: Column in set analysis

sunny_talwar — Wed, 14 Sep 2016 15:56:31 GMT

Is this what you want?

Expression:

FirstSortedValue(Valor, -AnoMes)

Re: Column in set analysis

Anonymous — Wed, 14 Sep 2016 19:06:33 GMT

Sunny ,

Thanks for answering.

I ended up putting the wrong example, I need it to be returned the sum of every month year sales maximum of each product and customer , in this example attached put another sale in 201607 and 201501 but the returned results are incorrect .

Re: Column in set analysis

sunny_talwar — Wed, 14 Sep 2016 19:32:26 GMT

How about this?

FirstSortedValue(Aggr(Sum(Valor), AnoMes, Cliente), -Aggr(AnoMes, AnoMes, Cliente))

Re: Column in set analysis

Anonymous — Thu, 15 Sep 2016 12:14:22 GMT

It was just that , thank you.