topic Re: FirstSortedValue - ignore selected field in QlikView

FirstSortedValue - ignore selected field

Anonymous — Wed, 04 Dec 2013 12:51:10 GMT

FirstSortedValue(COUNTRY, aggr(
(Sum ({1< FLAG = {'MND'},YEAR = {'$(vYear)'},MONTH = {'*'},F_PPP = {'>0'},T_PPP = {0} >} COUNTER) /
sum({1< FLAG = {'MND'},YEAR = {'$(vYear)'} ,MONTH={'*'},F_PPP={'>0'}>} F_CUSTOMER_BASE )
),COUNTRY))

The calculation is made correct. But I need to ignore the selected countries made in the listbox this influences the country returned by the expression.

any suggestions ?

thanks!

BR. Ben

Re: FirstSortedValue - ignore selected field

MK_QSL — Wed, 04 Dec 2013 13:14:19 GMT

Something like below..

FirstSortedValue(COUNTRY, aggr(
(Sum ({1< FLAG = {'MND'},YEAR = {'$(vYear)'},MONTH = {'*'},F_PPP = {'>0'},T_PPP = {0},COUNTRY = , >} COUNTER) /
sum({1< FLAG = {'MND'},YEAR = {'$(vYear)'} ,MONTH={'*'},F_PPP={'>0'},,COUNTRY = , >} F_CUSTOMER_BASE )
),COUNTRY))

Re: FirstSortedValue - ignore selected field

Anonymous — Wed, 04 Dec 2013 13:19:02 GMT

I tried that. The 1 in the formula alreay excludes made selections in the calculation.

thanks anyway

Re: FirstSortedValue - ignore selected field

jerem1234 — Wed, 04 Dec 2013 13:37:42 GMT

Think you might need a 1 in for firstsortedvalue if you want to ignore all selections or do Country =

Try:

FirstSortedValue({<COUNTRY= >}COUNTRY, aggr(
(Sum ({1< FLAG = {'MND'},YEAR = {'$(vYear)'},MONTH = {'*'},F_PPP = {'>0'},T_PPP = {0} >} COUNTER) /
sum({1< FLAG = {'MND'},YEAR = {'$(vYear)'} ,MONTH={'*'},F_PPP={'>0'}>} F_CUSTOMER_BASE )
),COUNTRY))

Or replace <COUNTRY= > with 1

Hope this helps!

Re: FirstSortedValue - ignore selected field

Anonymous — Wed, 04 Dec 2013 13:40:50 GMT

Thanks!
<COUNTRY= > did the trick