topic Re: Max date value for all dates in App Development

Max date value for all dates

surendraj — Sat, 16 Nov 2024 02:41:20 GMT

Hi All,

i have date and sales fields in a table as show below

Q_WK_ID	Sum(Sales)
5/4/2019	12292716
5/11/2019	12696990
5/18/2019	13225049
5/25/2019	13217132
5/2/2020	5678109

output required

Q_WK_ID	Sum(Sales)
5/4/2019	5678109
5/11/2019	5678109
5/18/2019	5678109
5/25/2019	5678109
5/2/2020	5678109

where i need replace the values with the max of date sales values . so whenever the user selects any date the above must be shown ,

how can we achieve this .. its urgent .. plz ...

i have tried using firstsortedvalue(sales,-q_wk_id) which did not work ..

thanks in advance

Re: Max date value for all dates

Vegar — Tue, 14 Apr 2020 20:49:54 GMT

Assuming that Q_WK_ID is formated as a date field. Try this expression:

sum({<Q_WK_ID={'$(=MaxString(Q_WK_ID))'}>}TOTAL Sales)

Re: Max date value for all dates

surendraj — Wed, 15 Apr 2020 04:56:42 GMT

Thanks for response ..

when i don't select the date .. i am getting the max date of sale vale ..

but when i select the date .. its not showing the correct value ..

however , i have given

sum({<Q_WK_ID={'$(=MaxString(Q_WK_ID))'},Q_WK_ID=>}TOTAL Sales)

still i m getting incorrect value when date is selected

Re: Max date value for all dates

Vegar — Wed, 15 Apr 2020 07:53:40 GMT

When you select [Date] you are actually combining the expression SET with your selection.

I do not know your data model and how date is correlated with Q_QK_ID, but in similar situations you some times want to ignore the [Date] selection and use an expression similar to this:

sum({<[Date]=, [Q_WK_ID]={'$(=MaxString([Q_WK_ID]))'}>}TOTAL Sales)

Re: Max date value for all dates

surendraj — Wed, 15 Apr 2020 08:14:46 GMT

date itself is Q_QK_ID.

i have written and i worked ..

sum({< [Q_WK_ID]={'$(=MaxString({<Q_QK_ID=>}[Q_WK_ID]))'}>}TOTAL Sales)

thanks for response ..