Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Become an analytics expert with Qlik's new 15 week course: Applied Data Analytics using Qlik Sense. READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Problem with date comparison

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...

1 Solution

Accepted Solutions
hector
Specialist
Specialist

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!

View solution in original post

2 Replies
hector
Specialist
Specialist

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!

View solution in original post

Not applicable
Author

Thanks Buddy

Bom dia pra você também. jajaja