topic Re: Date function in QlikView

Date function

mario-sarkis — Wed, 25 Nov 2020 16:16:04 GMT

Hey all

If i want to calculate a sum of an amount for max periode date of last year wut expression should i use ?

can anyone help?

Re: Date function

sunny_talwar — Tue, 15 Mar 2016 08:19:04 GMT

May be this:

Sum({<Date = {"$(=Date(Max({<Year = {$(=Max(Year) - 1)}>}Date), 'YourDateFieldFormatHere'))"}>}Amount)

Re: Date function

Chanty4u — Tue, 15 Mar 2016 08:19:34 GMT

sum({<Year={$(=Max(Year)-1)}>} <your field>)

Re: Date function

its_anandrjs — Tue, 15 Mar 2016 08:27:59 GMT

Try this

Sum({< [Date Field] = {"$(Addmonths([Date Field],-12 )" >} SalesAmt )

Regards,

Anand

Re: Date function

mario-sarkis — Tue, 15 Mar 2016 08:32:22 GMT

‌hi sunny thanks for your reply

just a question

if my format date is num it apply the same expression?

Re: Date function

sunny_talwar — Tue, 15 Mar 2016 08:33:59 GMT

If its a number, you can try this:

Sum({<Date = {"$(=Max({<Year = {$(=Max(Year) - 1)}>}Date))"}>}Amount)

Re: Date function

mario-sarkis — Tue, 15 Mar 2016 13:15:38 GMT

‌hi sunny

i need to ask you i tried the expression and it shows me a right answer bur the pro is that when i select on year or period it shows me zero you have an idea if its because the expression ?

HOpe you can help

Re: Date function

sunny_talwar — Tue, 15 Mar 2016 13:20:44 GMT

Try this to exclude any selection in any other date and time fields:

Sum({<Date = {"$(=Max({<Year = {$(=Max(Year) - 1)}>}Date))"}, Year, Month, MonthYear, Period>}Amount)

Re: Date function

mario-sarkis — Tue, 15 Mar 2016 14:18:18 GMT

thank you for your help this work perfectly ‌