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: 
anson_kong
Contributor II
Contributor II

ignore selection in firstsortedvalue()

hi all,

If I click the selection 'Store A', the Text Value in StoreB and StoreC is changed to null.

I would like to ignore the selection (Store) in my expression ,

the existing formula

=firstsortedvalue(TextValue,-(aggr(sum(Amount),Store,TextValue)))

StoreText Value
Ahjk
Boiu
Cqwe

thank you

1 Solution

Accepted Solutions
agigliotti
Partner - Champion
Partner - Champion

let's try as below:

=firstsortedvalue( {< Store= >} TextValue,-(aggr(sum( {< Store= >} Amount),Store,TextValue)))

View solution in original post

4 Replies
agigliotti
Partner - Champion
Partner - Champion

let's try as below:

=firstsortedvalue( {< Store= >} TextValue,-(aggr(sum( {< Store= >} Amount),Store,TextValue)))

YoussefBelloum
Champion
Champion

Hi,

try this:

=firstsortedvalue(TextValue,-(aggr(sum({<Store>}Amount),Store,TextValue)))

anson_kong
Contributor II
Contributor II
Author

it works

thank you

agigliotti
Partner - Champion
Partner - Champion

please close the thread marking the answer as correct to help other people.