topic show only one value based on count and alphabetical order in QlikView

show only one value based on count and alphabetical order

bharathkamath28 — Mon, 22 Feb 2021 12:46:44 GMT

Hi ,

I have a requirement to show single value in text box in qliksense based on two conditions.

1.return name based on max count(Path)

2. If multiple name has same count(Path) then pick alphabetical order of name.

If the input is

Return : ryan in text box as count(distinct Path) is more

If the input is

return: Andrew as count(Path)=3 in both the Names, so pick Andrew alphabetically.

Any suggestions are much appreciated.

Thanks,

Bharath

Taoufiq_Zarra — Mon, 22 Feb 2021 13:42:45 GMT

=FirstSortedValue(distinct Name,-aggr(count(Path)+Rank(Name,Name)/10,Name))

Examples :

bharathkamath28 — Tue, 23 Feb 2021 07:10:30 GMT

What if we want to show only those paths as a dimension in the table.

How can we achieve this?

Taoufiq_Zarra — Tue, 23 Feb 2021 07:46:20 GMT

@bharathkamath28 you can use Aggr function