topic Re: How to show value based on max reportdate in KPI chart in App Development

How to show value based on max reportdate in KPI chart

Anonymous — Mon, 30 Apr 2018 07:56:44 GMT

Hello,

I have values based on reportdates,

Under current selection, I want to show value in KPI chart according to max date among repordate.

for example: I want to show 1100 since, it is the latest date value (19.04.2018). Note: Report_Date and PeggedQty are field name.

thanks in advance

Thiago_Justen_ — Tue, 01 May 2018 12:15:25 GMT

May be this:

FirstSortedValue(PeggedQty,-Report_Date)

Anonymous — Tue, 01 May 2018 13:02:30 GMT

thank you but it did not work. Maybe I explained my issue wrong.

I want to sum all latest date values.

I try that:

sum({$<Report_Date={"$(=max(Report_Date))"}>}PeggedQty)

but it is not working either.

Qrishna — Tue, 01 May 2018 16:47:05 GMT

In script add a field

floor(num(Date#(Report_Date,'dd.mm.yyyy'))) as DateNum; // to retrieve string date field as num values to sort from min to max

put this expression in KPI:

=sum({$<DateNum = {'$(=max(DateNum))'}>}PeggedQty)

i am attaching a qlikview file over here.but the same applies for Qlik Sense too.

Thiago_Justen_ — Tue, 01 May 2018 19:40:19 GMT

Just format your date field to load script then your expression will work.

Date (Date#(Report_Date,'dd.mm.yyyy'),'dd.mm.yyyy') as Report_Date

Anonymous — Wed, 02 May 2018 06:05:21 GMT

Hello Krishna,

It summ up all dates value. It results 5600 instead of 1100

Qrishna — Fri, 11 May 2018 15:09:57 GMT

1100 is the max value and total is 5600.