topic Re: Sorting issue in Concat function in QlikView

Sorting issue in Concat function

kkkumar82 — Sun, 13 Mar 2016 16:15:45 GMT

All,

I have created a expression in text box as =Concat(SalesManID,',') and I am selecting a Product in the list box.

My requirement is

Would like to see all the SalesmanID associated with the selected product.

I was able to see them using concat but when I am trying to sort them descending by their sales I failed.

I think I missed some thing in the aggr I used for sort weight.

Thanks

Kiran kumar

Re: Sorting issue in Concat function

sunny_talwar — Sun, 13 Mar 2016 16:21:38 GMT

May be this:

=Concat(If(Aggr(Rank(Sum(Sales)),[Product ID],[Salesman ID])<=5,[Salesman ID]),',', Aggr(Rank(Sum(Sales)), [Product ID], [Salesman ID]))

Re: Sorting issue in Concat function

maxgro — Sun, 13 Mar 2016 16:26:24 GMT

try

=Concat(distinct [Salesman ID],',', -aggr(NODISTINCT sum(Sales),[Salesman ID],[Product ID]))

Re: Sorting issue in Concat function

kkkumar82 — Sun, 13 Mar 2016 17:24:41 GMT

Hi Maxgro,

I tried with altering the dimension list in aggr to ProductId and SalesmanId it was working fine, just curious to what "NoDistinct" is doing for sorting.

Can you delve here, about NoDistinct

Thanks

Kiran Kumar