Qlik calculation not working

[#1]

Hi,

The following calculation does not seem to work:

Sum({$<DATE={'$(=date(MAX(DATE)))'}>} Sales)

This has however worked in the past but am not sure whats wrong now.

[#2]

Ashfaq,

Please find the file attached. I have created a sample, could not sent the original

[ashfaq_haseeb]

Hi,

Issue with your field name.

You use wrong field name

Regards

ASHFAQ

[ashfaq_haseeb]

try this

=Sum({$<[Run Date]={'$(=date(max([Run Date]),'MM/DD/YYYY'))'}>} COUNT_PASS)

Regards

ASHFAQ

[aveeeeeee7en]

I have seen you QVW. There is format problem.

I've create an variable for Run_Date and change its format to number.

See the Attachment.

[tresesco]

The working expression is:

=Sum({$<[Run Date]={"$(=date(MAX([Run Date]),'MM/DD/YYYY'))"}>} COUNT_PASS)

[#7]

Ashfaq,

I do have a field called [Cound Pass] this was a copy paste error while creating the sample app.

[ashfaq_haseeb · Accepted solution]

Hi,

I have attached working qvw file.

=Sum({$<[Run Date]={'$(=date(max([Run Date]),'MM/DD/YYYY'))'}>} COUNT_PASS)

Regards

ASHFAQ

[#9]

Thanks for all the help guys! I really appreciate it... This is the best community ever ...

The thing that appears to be working is: Sum({$<[Run Date]={'$(=date(MAX([Run Date])))'}>}[Count Pass])

Which is kind of same as what I posted originally but in the meantime, I have changed the global date and time setting in the script and that appears to have resolved it. The date and timestamp format was mentioned differently and possibly that was causing issues.

[ashfaq_haseeb]

Hi,

Can you close this thread by selecting appropriate answer.

Regards

ASHFAQ