Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
@bharathkamath28 Maye be like :
=FirstSortedValue(distinct Name,-aggr(count(Path)+Rank(Name,Name)/10,Name))
Examples :
@bharathkamath28 Maye be like :
=FirstSortedValue(distinct Name,-aggr(count(Path)+Rank(Name,Name)/10,Name))
Examples :
Thanks @Taoufiq_Zarra
What if we want to show only those paths as a dimension in the table.
How can we achieve this?
@bharathkamath28 you can use Aggr function