Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

anson_kong
New 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
Honored Contributor II

Re: ignore selection in firstsortedvalue()

let's try as below:

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

4 Replies
agigliotti
Honored Contributor II

Re: ignore selection in firstsortedvalue()

let's try as below:

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

YoussefBelloum
Esteemed Contributor

Re: ignore selection in firstsortedvalue()

Hi,

try this:

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

anson_kong
New Contributor II

Re: ignore selection in firstsortedvalue()

it works

thank you

agigliotti
Honored Contributor II

Re: ignore selection in firstsortedvalue()

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