topic Re: Pick the max month end value in QlikView

Pick the max month end value

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

I have a calculated column lets name as sales,

I want to pick the Max value for the Month end dates. Need to find which month end date has highest value and month name.

sunny_talwar — Tue, 06 Mar 2018 12:54:27 GMT

Would you be able to share some sample data with expected output from the data that you provide?

Anonymous — Tue, 06 Mar 2018 12:59:39 GMT

I have calculated column g in my table chart now I need to find max and min month end values highlighted in yellow.

sunny_talwar — Tue, 06 Mar 2018 13:01:27 GMT

Is this something you need in the script or front end of the app?

Anonymous — Tue, 06 Mar 2018 13:03:40 GMT

Like in text object front end.

sunny_talwar — Tue, 06 Mar 2018 14:11:02 GMT

Do you want to sum the values highlighted in yellow? or average them? Since there are multiple values, how would you want to see them?

Anonymous — Tue, 06 Mar 2018 14:25:38 GMT

I want the sum highlighted in yellow since they are month end values.

I want to pick max and min of them

olivierrobin — Tue, 06 Mar 2018 16:30:47 GMT

hello,

to have the sum of the values,

first add tis expression in your load

if(date(TRANSACTION_DATE)=date(MonthEnd(TRANSACTION_DATE)),1,0) as LastDayofMonth,

it will determine if the date if ths last day of the month

then in a text box, use :

=sum(${<LastDayofMonth={'1'}>}MTD)

sunny_talwar — Wed, 07 Mar 2018 10:34:59 GMT

May be like this

Sum({<TRANSACTION_DATE = {"=TRANSACTION_DATE = Floor(MonthEnd(TRANSACTION_DATE))"}>}MTD)