topic Get max date from last month variable in QlikView

Get max date from last month variable

Anonymous — Thu, 16 Oct 2014 12:34:46 GMT

Hello,

The vlastmonth is a variable used to compute total. My question is how to get only the very latest date and its corresponding ie

25/09/2014 5,244.31

Tried to use the firstsortedvalue(amount,-Date) but returned null.

Please help

Re: Get max date from last month variable

MK_QSL — Thu, 16 Oct 2014 12:39:19 GMT

firstsortedvalue(Distinct amount,-Date)

Re: Get max date from last month variable

Thu, 16 Oct 2014 12:39:48 GMT

Hi,

you can use the below to get sales on latest date.

sum({<Date={'(=$(Max(Date)))'}>}amount)

Re: Get max date from last month variable

Anonymous — Thu, 16 Oct 2014 12:52:36 GMT

Hi Joe,

For the vLastMonth the last transactional date is 25/09/2014 not the the 30/09/2014 as we all know. The requirement is to display the amount for the last transactional date.That is where my challenge layst.

Manish and Shruthi I didn't get the desired results.

So how can I get the max date from the vlastMonth variable

Re: Get max date from last month variable

Thu, 16 Oct 2014 12:54:57 GMT

How have you defined vLastMonth? Should be able to just Max() on that to give you the date then

Re: Get max date from last month variable

Anonymous — Thu, 16 Oct 2014 12:57:23 GMT

vLastMonth=Month(date(AddMonths(max(Date), -1)))

Perhaps it's the date format?

Re: Get max date from last month variable

Thu, 16 Oct 2014 13:18:44 GMT

hello

if you mean by that you want the maximum date and its corresponding amount no matter what the active selection is you could create a variable for example vDateMax et put the following in it

=date(max({1}Date))

this will give the latest date no matter the selection and to get its corresponding amount

=only({<Date={"$(vDateMax)"}>}montant)

other wise to get the latest date and its amount , taking into account selections, you need to put =date(max(Date)) in

vDateMax .

See if it helps

Regards