topic Dynamic set analisys by each row in QlikView

Dynamic set analisys by each row

Anonymous — Tue, 06 Feb 2018 11:21:35 GMT

Hi Qlik experts,

I have a situation where I have a list of sellers which I desire to show the store where its seller made his/her last sell

I wanto show:

SalesmanName sum(SalesValue) Store

I tried

only(aggr(only({<Date= {"$(=only(aggr(max(Date),SalesmanName)))"}>} Store),SalesmanName))

sunny_talwar — Tue, 06 Feb 2018 12:46:04 GMT

May be try this

FirstSortedValue(Store, -Date)

Anonymous — Tue, 06 Feb 2018 12:58:50 GMT

Hi Sunny,

thanks for replying but it returned null for all cases in my set, even for one SalesmanName.

sunny_talwar — Tue, 06 Feb 2018 13:01:07 GMT

Would you be able to share a sample to see what you have?

Anonymous — Tue, 06 Feb 2018 13:32:36 GMT

follow attached

sunny_talwar — Tue, 06 Feb 2018 13:36:59 GMT

Can there be more than one store with the max date? If not, then try this

FirstSortedValue(DISTINCT Store,-Date)

for more than one store, you can try this

Concat(DISTINCT Aggr(If(Date = Max(TOTAL <SalesmanName> Date), Store), Date, SalesmanName))

Anonymous — Tue, 06 Feb 2018 14:07:21 GMT

It worked perfect with the distinct (the store is a date parameter)

thanks a lot Sunny