Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
neetu_singh
Partner - Creator III
Partner - Creator III

Need Help On Set Analysis

Hi All,

I need a help, actually I need a set analysis for YTD and MTD without using "inyeartodate" and "inmonthtodate" for current and previous financial year

.

Its urgent.

Kindly reply ASAP

Regards

Neetu Singh

1 Reply
Not applicable

Hi,
For example:

YTD

sum({$<Date = {">=$(=yearstart(ltoday()))<=$(=today()))"}, Year = , Month = , Day = >} amount)


MTD


sum({$<Date = {">=$(=monthstart(ltoday()))<=$(=today()))"}, Year = , Month = , Day = >} amount)

/@Ungvall