Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

homersimpson
Contributor II

Sum of measure from latest date

Hi,

in this thread i asked How to get the latest date of existing data

Now i want to get the sum of a measure, but only from the data with the latest date.

I try this, but get the sum from all data with older dates, too.

Sum({<myDate = {"=Max({<someMeasure = {'*'}>}myDate)"}>}Sales)

How can i get the sum only from the data with the latest date?


regards,

sam

1 Solution

Accepted Solutions
MVP
MVP

Re: Sum of measure from latest date

Try this

Sum({<myDate = {"$(=Max({<someMeasure = {'*'}>} myDate))"}>}Sales)

1 Reply
MVP
MVP

Re: Sum of measure from latest date

Try this

Sum({<myDate = {"$(=Max({<someMeasure = {'*'}>} myDate))"}>}Sales)