Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Become an analytics expert with Qlik's new 15 week course: Applied Data Analytics using Qlik Sense. READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

i want sum of sales for MOM and QOQ pls tell me how to write using setanalysis

i want sum of sales for  MOM  and  QOQ pls tell me how to write using setanalysis

1 Reply
mov
Champion III
Champion III

Month over Month:

sum({$<Year=,Quarter=,Month=>} if(InMonthToDate(Date,today(),0),Sales))

/

sum({$<Year=,Quarter=,Month=>} if(InMonthToDate(Date,today(),-1), Sales))

Quarter over Quarter is the same, only use InQuarterToDate() instead of InMonthToDate