topic Re: Variance analysis in QlikView

Variance analysis

Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Variance analysis

aarkay29 — Thu, 02 Mar 2017 19:37:56 GMT

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)

Re: Variance analysis

Peter_Cammaert — Thu, 02 Mar 2017 19:51:06 GMT

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.