topic Re: return the most frequent asset in QlikView

return the most frequent asset

samuel_brierley — Sun, 19 Jul 2015 10:43:31 GMT

Hi all,

I have a table like the one below that counts the number of times an asset appears and then sorts highest to lowest.

I have a formula that goes in a text box =Max ( aggr ( count ( Equipment_Id ),Equipment_Id ) ) that returns the 699 as you would expect. what im after is to return the actual Equipment ID.

thanks all

Re: return the most frequent asset

Kushal_Chawda — Sun, 19 Jul 2015 10:49:49 GMT

Try,

Firstsortedvalue( Equipment_Id, -aggr ( count ( Equipment_Id ),Equipment_Id ))

Re: return the most frequent asset

samuel_brierley — Sun, 19 Jul 2015 10:56:05 GMT

Thanks for the quick reply, I thought it would be something like that however couldn't quite figure the syntax.

Re: return the most frequent asset

maxgro — Sun, 19 Jul 2015 11:00:24 GMT

it seems the formula works

Re: return the most frequent asset

Kushal_Chawda — Sun, 19 Jul 2015 11:00:48 GMT

I had modified the syntax

Firstsortedvalue( Equipment_Id, -aggr ( count ( Equipment_Id ),Equipment_Id ))