Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Problem comparing dates after Max and Aggr functions

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.



5 Replies
MVP
MVP

Problem comparing dates after Max and Aggr functions

Hi,

have you tried to quote variable T2?

...< '$(T2)'


- Ralf

Not applicable

Problem comparing dates after Max and Aggr functions

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

MVP
MVP

Problem comparing dates after Max and Aggr functions

Can you post an example app?

- Ralf

Not applicable

Problem comparing dates after Max and Aggr functions

Sorry Ralph, but i can't post data.

MVP
MVP

Problem comparing dates after Max and Aggr functions

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

- Ralf

Community Browser