Set Analysis

spsrk_84 — Tue, 02 Aug 2011 08:33:35 GMT

Hi All,

I am facing one problem with the set analysis.In my applicatin data there are two quarter fields one which is represented in numeric formats like

20091,20092 and so on.. from this i calculated the Q1,Q2,Q3,Q4 i.e in this way ( 'Q' &right(Quarter,1) ).

Now the problem i have to write expression for calculating the current Vs previous quarter this is also working fine. but when i select 2011 Q1 the comparision has to be done like 2011 Q1 Vs 2010 Q4.

For this i have created a variable which will give me the corresponding values when i select Quarter.

The Variables used are

PrevYear =IF(Right(MAX(Quarter),1)=1,Max(Year)-1,Max(Year))

PrevQtr =IF(Right(MAX(Quarter),1)=1,NUM(Max(Quarter)-7),NUM(Max(Quarter)-1))

My Gauge Chart expression

(
(
(sum({<Year={$(=MAX(Year))},[Quarter] = {$(=Max(Quarter))}>}[Revenue_USD]) + sum({<Year={$(=MAX(Year))},[Quarter] = {$(=Max(Quarter))}>}[Rebates]))
-
(sum({<Year={$(=vPrevYear)},[Quarter] = {$(=vPrevQtr)}>}[Revenue_USD]) + sum({<Year={$(=vPrevYear)},[Quarter] = {$(=vPrevQtr)}>}[Rebates]))
)
/
(sum({<Year={$(=vPrevYear)},[Quarter] = {$(=vPrevQtr)}>}[Revenue_USD]) + sum({<Year={$(=vPrevYear)},[Quarter] = {$(=vPrevQtr)}>}[Rebates]))
)

The above expression works fine when i select the values in quarter listbox which is having numeric values like 2009,20092.......20111.

But when i select the values in Listbox Qtr like Q1 Q2 Q3 Q4 this is not working...Chart shows no data to display .

I checked the expression also ,values are passed properly to the set expression but it is not showing any data for prev qtr.

Did i missed something in variable expression or even in Chart expression..please let me know.

Regards,

Shiva

Set Analysis

ToniKautto — Tue, 02 Aug 2011 08:37:32 GMT

Please attach a sample QVW to make evaluation of your case easier.

Re: Set Analysis

danielrozental — Tue, 02 Aug 2011 15:06:18 GMT

You're file is too big, try posting a smaller one.

topic Set Analysis in QlikView

Set Analysis

Set Analysis

Re: Set Analysis