topic Re: Dimension in a KPI in App Development

Dimension in a KPI

leefraser — Fri, 24 Aug 2018 08:46:42 GMT

Good morning, I am trying to return our busiest month in a KPI.

I can see the data in a table

Dimension = (Month) NB month is a field within our data

Measure = count(Report)

However I just want the busiest month to return in a KPI when I choose year, or a range of months from a filter.

I have used =maxstring(month) I beleive this is returning the longest word and is incorrect ???

I have also tried =FirstSortedValue([Month],aggr(count(Report),[Month])) however I am receiving a '-'

Can anyone advise on a solution for this issue ??

Any help would be appreciated.

Thank you

Arthur_Fong — Fri, 24 Aug 2018 16:12:34 GMT

Hi Lee,

Refer to the attachment below and look at the max sales column expression.

Thanks and regards,

Arthur Fong

enriquejts — Fri, 24 Aug 2018 17:04:34 GMT

hello I'm new to this but you could try the next formula in measurements

Max(informes)

and so that the name of the month appears on the label you can use the following expression

=FirstSortedValue (mes, informes,Count(mes))

BalaBhaskar_Qlik — Sat, 25 Aug 2018 13:30:46 GMT

May be use this:

=Aggr(Only({<Sales = {'$(=Max(Sales))'}>}Month),Month)

BalaBhaskar_Qlik — Sat, 25 Aug 2018 13:31:24 GMT

=Only({<Sales = {'$(=Max(Sales))'}>}Month)

karthiksrqv — Sat, 25 Aug 2018 14:46:30 GMT

Can you see if this approach is workable:

SubField(

mid(

concat(distinct aggr(count(ReportField)&'|'&concat(distinct Monthfield),Monthfield),','),

findoneof(

concat(distinct aggr(count(ReportField)&'|'&concat(distinct Monthfield),Monthfield),','),

max(aggr(count(ReportField),Monthfield),',')

)

'|',

)

leefraser — Mon, 03 Sep 2018 13:07:17 GMT

Hi all, thank you for posting your options. We have found a way that works to retrive the most common (or busiest month)

=mode(Month)

This returns text in a KPI and shows the name of the month with the highest number of reports.