Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
qlikuserkv
Contributor III
Contributor III

Set Analysis Date range

Hello,

I use this formula in my bar chart.

Sum({<Month = {"$(='>=1<=' & Num(Month(Max({1}Date))))"}, Year>} Measure)


I have information until March 12 and this calculates me  Sum in January February and March in all of the years. I want to have the sum in all of these years until March 12 . I added the day , but it doesn't work correctly


Sum({<Month = {"$(='>=1<=' & Num(Month(Max({1}date))))"},

Day= {"$(='>=1<=' & Num(Day(Max({1}date))))"}, Year>} FactSoldAmount)

Thank you, in advance

1 Solution

Accepted Solutions
sunny_talwar

Try this

Sum({<Date = {"=SetDateYear(Only({1} Date), Year(Today())) <= SetDateYear(Max({1} TOTAL Date), Year(Today()))"}, Year, Month>} Measure)

View solution in original post

4 Replies
sunny_talwar

Try this

Sum({<Date = {"=SetDateYear(Only({1} Date), Year(Today())) <= SetDateYear(Max({1} TOTAL Date), Year(Today()))"}, Year, Month>} Measure)

qlikuserkv
Contributor III
Contributor III
Author

It works Thanks !!!!!!!!!!!  I really appreciate your help

MK_QSL
MVP
MVP

Excellent... this is the first time I can see use of this function..!!!

sunny_talwar

... Ya this get rarely used, but can come in handy when we have to disregard the year part and make decision based on day and month...