Qlik Community

Qlik DataMarket Discussions

Discussion Board for collaboration regarding Qlik DataMarket.

Highlighted
mhmhmh91
New Contributor

Get the "FirstSortedValue" with aggregation calculation

I have a table like below

DateWeedkayHourCount
2018-01-01Mon1100
2018-01-01Mon2200
2018-01-01Mon350
2018-01-02Tue1120
2018-01-02Tue

2

80
2018-01-02Tue355
2018-01-03Wed1200
2018-01-03Wed2100
2018-01-03Wed3105

I would like to have 2 text objects to show the Weekday with most count (Wed in the example) and hour with most count (Hour 1 in the example).

I have tried FirstSortedValue but it doesn't allow nested aggregation.

Anyone can help? Thank you in advance!

Community Browser