Set Analysis - Three Months

[Anonymous]

Hi, I would like to apply set analysis to the attached table, comparing three months, per location. Thanks

[qlikviewwizard]

Hi,

Please check this Jagan's links:

Set Analysis for certain Point in Time

Set Analysis for Rolling Periods

[MK_QSL]

Where is Location in your excel file? Is that Branch?

Also, what is meant by comparing three months? Can you provide expected output in excel?

[#4]

Hi Faisal

do you mean some thing like this,

if not please provide sample result

[Anonymous]

Manish, Location is Branch !!

And see my original post for the excel. I have attached excel file !!

Comparing 3 months as below...!!

	Jul	Aug	Sep
BR	---	---	---
HK	---	---	---
	---	---	---

[#6]

Hi Faisal

use branch & month as dimension,

then drag the month to the top of table.

[#7]

Can you check the attach

Regards

[#8]

Excuse the previus qvw had an error in the current month formula

Check the new attachment

[teiswamsler]

Hi Faisalaaa

This set analysis will dynamic present the sales for current month and last 2 month - from max selected date

Sum( {$<CalenderYear, CalenderMonth, CalenderQuater, Date = {">=$(=Floor(Addmonths(Monthstart(Max(Date)), -3 )))<=$(=Max(Date))"} >} Sales )

Ex for dimensions

Salespersonal

YearMonth

/Teis

[Anonymous]

I do not have Year or Quarter nor Date.

Only Months !