topic Re: Set Analysis not working???? in QlikView

Set Analysis not working????

Thu, 24 Oct 2013 09:03:27 GMT

Hi All

I have a point in time set analysis that should be returning the value for latest period - 11:

Avg({$<BasketFC.PeriodID = {"=$(=Max(BasketFC.PeriodID) - 11)"}>} BasketFC.BasketPercentage)

But for a reason I cannot fathom it's ignoring the Set completely?

But the following works:

=Avg({$<BasketFC.PeriodID = {1}>} BasketFC.BasketPercentage)

I've checked that =Max(BasketFC.PeriodID) - 11 does equal 1.....?

Please can anyone advise where I'm going wrong with this?

Thanks

Dominic

sushil353 — Thu, 24 Oct 2013 09:10:21 GMT

hi,

Try this:

Avg({$<BasketFC.PeriodID = {"=$(=Maxstring(BasketFC.PeriodID) - 11)"}>} BasketFC.BasketPercentage)

HTH

Sushil

Thu, 24 Oct 2013 09:18:53 GMT

Hi Sushil

That didn't make a difference?

Dom

rajni_batra — Thu, 24 Oct 2013 09:24:25 GMT

Try

Avg({$<BasketFC.PeriodID = {"$(=BasketFC.PeriodID)-11)"}>} BasketFC.BasketPercentage)

Thu, 24 Oct 2013 09:24:31 GMT

Figured it out! I needed to remove the quotes:

Avg({$<BasketFC.PeriodID = {$(=Max(BasketFC.PeriodID) - 11)}>} BasketFC.BasketPercentage)