Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
niranjana
Creator
Creator

Date expression

Hi, I have a situation where I have date field "Movement date" in the date format "19/09/2023".  i need to calculate count of claims.

I wrote this expression :

" count({$<[Movement Date]={"= $(Date(max([Movement Date])-1),'DD/MM/YYYY')"}>}[Claim Number]) " .

I also tried this expression : "count({$<[Movement Date]={"= $(=max([Movement Date]))"}>}[Claim Number])"

The expression shows ok, but the result is 0,  or it doesn't show any result. The count must show as 2258.

Any help is appreciated.

Thanks in advance,

Niranjana

Labels (1)
2 Solutions

Accepted Solutions
justISO
Specialist
Specialist

Hi, try this:

=count({$<[Movement Date]={"$(=(Date(max([Movement Date])-1,'DD/MM/YYYY')))"}>}[Claim Number])

View solution in original post

justISO
Specialist
Specialist

I changed 2 parts, bracket place and this '{"= $(' part to '{"$(=(, but I don't know which change corrected the formula. I'll probably never learn to write set analysis correctly, so I always have a few examples saved to check syntax which works 🙂

View solution in original post

4 Replies
justISO
Specialist
Specialist

Hi, try this:

=count({$<[Movement Date]={"$(=(Date(max([Movement Date])-1,'DD/MM/YYYY')))"}>}[Claim Number])

niranjana
Creator
Creator
Author

HI , Thanks a lot!! It worked..is it because of bracket?

 

justISO
Specialist
Specialist

I changed 2 parts, bracket place and this '{"= $(' part to '{"$(=(, but I don't know which change corrected the formula. I'll probably never learn to write set analysis correctly, so I always have a few examples saved to check syntax which works 🙂

niranjana
Creator
Creator
Author

Thanks  a lot! same issue is there...that of brackets.....ur explanation and having syntaxes is bang on!