comparing different dimensions member values

Tue, 19 Jul 2011 01:11:21 GMT

Hello,

One of the calculations that I am working on requires an evaluation of the yearly average value at the month level. For example, If January is greater than the yearly average then take the yearly average value otherwise, use the current month value. How would I do this? I tried to evaluate it like this:

IF (

avg(
aggr(
DISTINCT
(
($(varAvgDailyCensus) * $(varPaidHourPerStat) *$(varDaysInMonth) ) /
(2080/365* $(varDaysInMonth) )
),FORECAST_LEVEL_DESC, SCENARIO_DESC, MONTH,DEPT_NAME
)
)

>

avg(
aggr(
DISTINCT
(
($(varAvgDailyCensus) * $(varPaidHourPerStat) *$(varDaysInMonth) ) /
(2080/365* $(varDaysInMonth) )
),FORECAST_LEVEL_DESC, SCENARIO_DESC,YEAR,DEPT_NAME
)
)

,1,0
)

If I break each of these statements up, they work...however, if I try to evaluate them in an if statement, it doesnt work.

Qlikview syntax is relatively new to me...if this was SSAS, I would be done really quick!

Thanks,

Joe

comparing different dimensions member values

Tue, 19 Jul 2011 19:26:04 GMT

Any takers?

topic comparing different dimensions member values in QlikView

comparing different dimensions member values

comparing different dimensions member values