topic Re: Set Analysis, Previous Period, Change on Diemension in QlikView

Set Analysis, Previous Period, Change on Diemension

Thu, 27 Aug 2015 13:14:40 GMT

Hi,

Looking forward to solutions to the following situation:

Show Previous Year Total (single figure ) based on current selections in the Year Field

Selections in the Quarter, Month and Day should not cause recalculation in the Previous Year Total

However, selection on other dimensions (Country, City, Product, Category) should cause recalculation in the Previous Year Total.

thanks in advance !

Re: Set Analysis, Previous Period, Change on Diemension

sunny_talwar — Thu, 27 Aug 2015 13:18:19 GMT

May be this:

=Sum({<Year = {"$(=Max(Year) - 1)"}, Quarter = , Month = , Day = >} FieldName)

Re: Set Analysis, Previous Period, Change on Diemension

Thu, 27 Aug 2015 14:32:41 GMT

No this is not going to work. since, the year field is already selected therefore rest of the data is filtered and previous year could never be selected. For this i will have to use 1 instead of $. But the problem is that the data will remain the same. However, i want it to change on some dimensions and not on some dimensions and still be able to use current selection to calculate previous year.

I have figured out a way and seems to have worked nevertheless the results are not accurate. I have used following:

Sum( {
		1 <
			[Fiscal Month #]=,
			Day=,
			Quarter=,
			[Fiscal Year #] = { $(=Max( [Fiscal Year #])-1 ) }
			,
			Country = p({$} Country) ,
			City = p({$} City),
			Group = p({$} Group),
			[Sub-Category] = p({$} [Sub-Category]),
			[Product Details] = p( {$} [Product Details])
		>
	} Amount )

Re: Set Analysis, Previous Period, Change on Diemension

sunny_talwar — Thu, 27 Aug 2015 20:40:17 GMT

What do you exactly mean when you say the results are not accurate? What is the problem?

Re: Set Analysis, Previous Period, Change on Diemension

qlikviewwizard — Fri, 28 Aug 2015 05:30:03 GMT

Hi,

Can you attach the sample file with the data?