Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Dynamic set analisys by each row

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

but that returs null when I select more than one Date. It works when I select salesmen with the same last sales date, but that is not valid for the whole set.

Thanks in advance.

RS

1 Solution

Accepted Solutions
sunny_talwar

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


Capture.PNG

View solution in original post

6 Replies
sunny_talwar

May be try this

FirstSortedValue(Store, -Date)

Anonymous
Not applicable
Author

Hi Sunny,

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

sunny_talwar

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

Anonymous
Not applicable
Author

follow attached

RS

sunny_talwar

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


Capture.PNG

Anonymous
Not applicable
Author

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

thanks a lot Sunny

RS