topic Problem with date comparison in QlikView

Problem with date comparison

Mon, 17 Jan 2011 14:49:21 GMT

Hello everyone. I am new at the community and I need some help.

I'm trying to compare a date field (dtMovimentation) with the higher field of the same table.
Example:

Sum ({<dtMovimentation = $ (={ Max (dtMovimentacao), 'DD / MM / YYYY'))}>} SUM_qtMovimentation)

But it is not working, I guess it is for some stupid mistake but I'm not finding it.

Sorry for my english mistakes, I'm from Brazil and I'm studing to improve my skills.

Thaks for any help...

Problem with date comparison

hector — Mon, 17 Jan 2011 14:53:59 GMT

Hi, you have a problem with the sintax

Correct it like this

Sum ({<dtMovimentation = {$(=Max(dtMovimentacao) )}>} SUM_qtMovimentation)

this will work, anyway if you need to do some format use this

Sum ({<dtMovimentation = {$(=date(Max(dtMovimentacao),'DD/MM/YYYY'))}>} SUM_qtMovimentation)

Bom dia pra vc!

Problem with date comparison

Mon, 17 Jan 2011 17:02:30 GMT

Thanks Buddy

Bom dia pra você também. jajaja