topic Problem comparing dates after Max and Aggr functions in QlikView

Problem comparing dates after Max and Aggr functions

Tue, 19 Apr 2011 11:50:34 GMT

Hi,

i have a big mistake regarding following calculated dimension:

if(date(Aggr($(Max_), PRODUCT_CODE))<$(T2), date(Aggr($(Max_), PRODUCT_CODE),null())

with this Max_ = date(Max({$<RicevConsum.POST_DATE={'<=$(=$(T1))'},RicevConsum.TIPO={CONS,REC}>}RicevConsum.POST_DATE))

This expression works only with <'dd/mm/yyyy' in place of $(T2), i need to filter the aggr results using a date stored in variable, instead of date value ('18/10/2010').

Many thanks at all.

Problem comparing dates after Max and Aggr functions

rbecher — Tue, 19 Apr 2011 12:48:36 GMT

Hi,

have you tried to quote variable T2?

...< '$(T2)'

- Ralf

Problem comparing dates after Max and Aggr functions

Tue, 19 Apr 2011 13:51:50 GMT

Yes Ralph, i've tried this <'$(T2)' but the filter has no effects, results contains all possible dates.

Problem comparing dates after Max and Aggr functions

rbecher — Tue, 19 Apr 2011 13:59:14 GMT

Can you post an example app?

- Ralf

Problem comparing dates after Max and Aggr functions

Tue, 19 Apr 2011 14:09:51 GMT

Sorry Ralph, but i can't post data.

Problem comparing dates after Max and Aggr functions

rbecher — Tue, 19 Apr 2011 14:23:28 GMT

You could load some demo data (inline?)...

- Ralf