Skip to main content
Announcements
Introducing a new Enhanced File Management feature in Qlik Cloud! GET THE DETAILS!
cancel
Showing results for 
Search instead for 
Did you mean: 
hiringel
Contributor III
Contributor III

Larger or equal to YearMonth in set analysis

Hey,

This formula works great for getting the RWA value from 6 months back:

Sum(

{<YearMonth={"$(=date(AddMonths(Max({<RWA={"=(Len(RWA)>=0)"}>}YearMonth),-6),'YYYYMM'))"}>}

RWA)

How do I make it fill a chart with all values 6 months back, in other words, what is the syntax for  ">=", the "larger than or equal to" set analysis?

10 Replies
antoniotiman
Master III
Master III

Try this

Sum(
{<YearMonth={">=$(=Num(date(AddMonths(Max({<CostOfCredit={">0"}>}YearMonth),-12),'YYYYMM')))"
}>}
CostOfCredit)