Dollar Sign Expansion Question

darrellbutler — Wed, 10 Aug 2011 10:00:38 GMT

Hello, I have the following set analysis expression that I have set as a variable. However when i use this in subsequent formulas/expressions via dollar sign expansion it doesn't appear to work.

=Avg({1<[ACCOUNTING_PERIOD] = {$(v1AccPeriodAgo) , $(vCurrAccPeriod) , $(v2AccPeriodAgo) }, [ACCOUNTING_YEAR] = {$(vCurrAccYear) }>} Cost) .

When used without expansion it pulls back the desired result. However a fter expansion the formula looks like:

=Avg({1<[ACCOUNTING_PERIOD] = {=5- 1, 5, =5- 2}, [ACCOUNTING_YEAR] = {2012}>} Cost])

The AccPeriod variables are derived as follows: '=$(vCurrAccPeriod)- 1'

Has anybody got any tips on how to set the formula as a variable and then use it in further expansion.

Regards

Darrell.

Re: Dollar Sign Expansion Question

lironbaram — Wed, 10 Aug 2011 10:17:01 GMT

hei

attach is an example

you need to use Quats when using varaibles in set analsys

topic Dollar Sign Expansion Question in QlikView

Dollar Sign Expansion Question

Re: Dollar Sign Expansion Question