Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Variance analysis

Hi

I am trying to do variance analysis. I have attached a excel sheet of sample data. The variance analysis is Month over Month and Quarter Over Quarter. I already have all the data is my data model

Thanks

Priya

2 Replies
aarkay29
Specialist
Specialist

Something like this using Set Analysis

sum({$<Date={"<=$(=Max(Date))>=$(=MonthStart(Max(Date)))"}>}Sales)-

sum({$<Date={"<=$(=MOnthEnd(AddMonths(Max(Date),-1)))>=$(=MonthStart(Addmonths(Max(Date),-1)))"}>}Sales)

sum({$<Date={"<=$(=Max(Date))>=$(=QuarterStart(Max(Date)))"}>}Sales)-

sum({$<Date={"<=$(=QuarterStart(Max(Date))-1)>=$(=QuarterStart(QuarterStart(Max(Date))-1))"}>}Sales)

Peter_Cammaert
Partner - Champion III
Partner - Champion III

Useful blog post by HIC: Year-over-Year Comparisons

Somwhere along the thread, discussions mention Month-over-month. Q-over-Q can be deduced from there on.