Using result of an Expression in Aggregate function

Wed, 25 Nov 2020 16:16:04 GMT

Hello All,

I am trying to use result of one of my expression in an aggregate function. But it says "bad field name". I know we cannot use them inside aggregate function. Is there any alternative to do this? Below is an Example.

Exp1: date(salesdate) - Label- Startdate

Exp2: Sum(if(salesdate>=Startdate and salesdate<=addmonths(Startdate,6),SalesQuantity,0))

Re: Using result of an Expression in Aggregate function

swuehl — Thu, 08 Sep 2016 17:41:13 GMT

In this specific case, date(salesdate) is just formatting the salesdate value to a date format.

In Exp2, you don't need a formatted date to make your numeric comparisons, so you could just write

=Sum(If(salesdate >= salesdate and salesdate <= addmonths(salesdate,6), SalesQuantity,0))

But the date comparisions are always true, right?

So I guess that's not what you want (but it has nothing to do with expression referencing then, too).

topic Using result of an Expression in Aggregate function in QlikView

Using result of an Expression in Aggregate function

Re: Using result of an Expression in Aggregate function