topic textbox rank sum set analysis in QlikView

textbox rank sum set analysis

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

hi there,

ı have a table like that ;

I want to write in the textbox that ;

'in the last (12) months of term, rank=1 and rank=2 sum(sales) are .99., 96... and in these months are .201709 and 201702. '

again I am having difficulty with the syntaxes of set analysis......

aarkay29 — Tue, 14 Nov 2017 16:52:42 GMT

try this

FirstSortedValue({$<term={">=$(=Date(addmonths(Max(term),-11)))"}>}sales,-sales,1)

FirstSortedValue({$<term={">=$(=Date(addmonths(Max(term),-11)))"}>}sales,-sales,2)

antoniotiman — Tue, 14 Nov 2017 17:03:47 GMT

May be this

vishsaggi — Tue, 14 Nov 2017 17:05:59 GMT

May be other ways like below:

= '1st: ' & Max(Aggr(Sum(sales), term),1) & Chr(13) &

'2nd: ' & Max(Aggr(Sum(sales), term),2) & Chr(13) & 'OR' & Chr(13) &

'1st: ' & FirstSortedValue(sales, -Aggr(Sum(sales), term),1) & Chr(13) &

'2nd: ' & FirstSortedValue(sales, -Aggr(Sum(sales), term),2)

YoussefBelloum — Tue, 14 Nov 2017 17:08:02 GMT

try this:

'in the last (12) months of term, rank=1 and rank=2 sum(sales) are'

&Sum({<term = {"=Rank(Sum({<term>}sales)) = 1"}>}sales)

&' and '

& Sum({<term = {"=Rank(Sum({<term>}sales)) = 2"}>}sales)

antoniotiman — Tue, 14 Nov 2017 17:08:43 GMT

Text Box

=Concat({<term={"=Rank(Sum(sales),0,1) <= 2"}>} term&' '&'Sales = '&sales,Chr(10),-sales)

vishsaggi — Tue, 14 Nov 2017 17:12:25 GMT

And to get the dates try

'1st:' & FirstSortedValue(term & ':' & sales, -Aggr(Sum(sales), term),1) & Chr(13) &

'2nd:' & FirstSortedValue(term & ':' & sales, -Aggr(Sum(sales), term),2)

Anonymous — Wed, 15 Nov 2017 12:11:12 GMT

not work