topic Re: Date expression in QlikView

Date expression

jduluc12 — Wed, 29 Mar 2017 12:01:35 GMT

Hi,

Suppose if today is 03/23/2017 and i want to build an expression for sum of amount

from 04/23/2016 to 05/23/2016 then how to build it.

what should be the set analysis for it?

sum({<>}Amount).

Thanks,

Jean

Anonymous — Wed, 29 Mar 2017 12:07:58 GMT

Try something like this by creating a datenum field

{<numDate = {">= $(=num(Max(AddMonths(Date,-10)))) <=$(=num(Max(AddMonths(Date,-11)))) "}>}

sunny_talwar — Wed, 29 Mar 2017 12:14:30 GMT

May be this

Sum({<DateField = {"$(='>=' & Date(AddYears(AddMonths(Today(), 1), -1)) & '<=' & Date(AddYears(AddMonths(Today(), 2), -1)))"}>}Amount)