Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

etrotter
Contributor II

MTD set analysis

Hi, could you please let me know what I'm doing wrong:

Sum({$<Month(Date)=$(vCurrentMonth)>}[Total Revenue])

vCurrentmonth=Max(Month(Date))

Thanks in advanced!

1 Solution

Accepted Solutions
etrotter
Contributor II

Re: MTD set analysis

Got it!

Sum({<[EntryYearMonth]={"$(=MaxString([EntryYearMonth]))"}>}[Total Revenue])

3 Replies

Re: MTD set analysis

You cannot use Function on the left hand side of the set modifier... create Month(Date) as Month in the script and then use it like this

Sum({<Month = {'$(=Max(Month)'}>} [Total Revenue])

etrotter
Contributor II

Re: MTD set analysis

its still not working, I do have a 'month' field in the model but it is unrelated to total revenue. The table is related to the 'date' field

etrotter
Contributor II

Re: MTD set analysis

Got it!

Sum({<[EntryYearMonth]={"$(=MaxString([EntryYearMonth]))"}>}[Total Revenue])

Community Browser