topic Re: Set Analysis - Three Months in QlikView

Set Analysis - Three Months

Anonymous — Thu, 10 Sep 2015 11:37:38 GMT

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

Re: Set Analysis - Three Months

qlikviewwizard — Thu, 10 Sep 2015 11:41:46 GMT

Hi,

Please check this Jagan's links:

Set Analysis for certain Point in Time

Set Analysis for Rolling Periods

Re: Set Analysis - Three Months

MK_QSL — Thu, 10 Sep 2015 11:42:30 GMT

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?

Re: Set Analysis - Three Months

Thu, 10 Sep 2015 12:15:57 GMT

Hi Faisal

do you mean some thing like this,

if not please provide sample result

Re: Set Analysis - Three Months

Anonymous — Thu, 10 Sep 2015 12:23:29 GMT

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	---	---	---
	---	---	---

Re: Set Analysis - Three Months

Thu, 10 Sep 2015 12:32:07 GMT

Hi Faisal

use branch & month as dimension,

then drag the month to the top of table.

Re: Set Analysis - Three Months

Thu, 10 Sep 2015 12:34:39 GMT

Can you check the attach

Regards

Re: Set Analysis - Three Months

Thu, 10 Sep 2015 12:37:11 GMT

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

Check the new attachment

Re: Set Analysis - Three Months

teiswamsler — Thu, 10 Sep 2015 12:49:46 GMT

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

Re: Set Analysis - Three Months

Anonymous — Thu, 10 Sep 2015 13:03:13 GMT

I do not have Year or Quarter nor Date.

Only Months !

Re: Set Analysis - Three Months

Thu, 10 Sep 2015 13:12:29 GMT

Sorry you checked the attachment that you have sent?
Should solve the problem for your case.

Re: Set Analysis - Three Months

MK_QSL — Thu, 10 Sep 2015 13:50:18 GMT

Create a Pivot Table

Dimension

Branch

Month

Expression

SUM([Received Amt])

Re: Set Analysis - Three Months

Anonymous — Sun, 13 Sep 2015 07:10:54 GMT

The table you have created does not change when selecting Location ( Branch) from the drop List !!

example: If I selected "Aug" table should show Aug and Jul and its variation.

Re: Set Analysis - Three Months

Anonymous — Wed, 07 Oct 2015 08:35:49 GMT

Not solved yet !!