topic Date comparision with variable in QlikView

Date comparision with variable

Fri, 26 Jun 2009 15:06:17 GMT

Dear All,

I defined variable as ANALYSIS_DATE type date; I have field as TDate; I want to sum AMOUNT which is below the ANALYSIS_DATE;

My expression: =sum(all (if(TDate < max(ANALYSIS_DATE), AMOUNT)) is not working; please guide me.

Thanks

Eshack

Date comparision with variable

Fri, 26 Jun 2009 16:06:57 GMT

can you try this

=If(TDate < max(Analysis_date), sum(Amount))

-Raghu.

Date comparision with variable

Fri, 26 Jun 2009 16:11:16 GMT

Hi,

Try out this below expression

=sum(all (if(TDate < max(total ANALYSIS_DATE), AMOUNT))

- Sridhar

Date comparision with variable

Anonymous — Fri, 26 Jun 2009 23:12:35 GMT

Eshack,
If the ANALYSIS_DATE is a variable, I don't understand the need of max(). So, this should be enough
=sum(all (if(TDate < ANALYSIS_DATE, AMOUNT))
Make sure that the format of Date and ANALYSIS_DATE are both date or number.
(I don't see the need of "all" qualifier in this case, but hope you know what you're doing.)

Date comparision with variable

Oleg_Troyansky — Sat, 27 Jun 2009 01:53:18 GMT

I found Date comparizon quite tricky, because of the dual nature of Dates. I'm usually casting them to numerics, just to make sure that I'm comparing the same values:

if( num(Date1) = num(Date2) ...

Oleg