topic help: set analysis inside a variable in QlikView

help: set analysis inside a variable

Thu, 10 May 2012 01:45:02 GMT

Hi,

expression box:

vF1Type - 'A','B','C','D'

vF2Type - 'Value1','Value2'

I have this expression:

(Sum( {<Field1={$(vF1Type)},Field2={$(vF2Type)}>} Sales * [Transaction Quantity])/1000000)

/+ (Sum({<Field1={$(vF1Type)},Field2={'Miscellaneous receipt'},Field3={'OUTS'}>} Sales * [Transaction Quantity])/1000000)

I stored this inside a variable but when i call the variable in the expression of a pivot table it doesnt give me the correct value.

What did i do wrong??

help: set analysis inside a variable

Thu, 10 May 2012 01:46:54 GMT

i want this formula to generate values by quarter

help: set analysis inside a variable

qlikviewajeet — Thu, 10 May 2012 04:16:43 GMT

can u plz share your document.

help: set analysis inside a variable

Thu, 10 May 2012 07:34:43 GMT

help: set analysis inside a variable

varunpbhandary — Thu, 10 May 2012 10:02:06 GMT

Hi Mars,

You Cannot Use a Variable Directly inside the Value field of set analysis, What you can do is Build the expression as a variable and the value you want to put in set analysis as another variable and in the expressions tab use the final expression's variable.

for eg.

MaxCurrDate ---> max(CurrDate)

Expression ---> 'sum({$<CurrDate = {"'&MaxCurrDate&'"},Metric_Name={USD}>} [INR/1 Unit])'

then use the Expression's variable in expressions tab

help: set analysis inside a variable

Fri, 25 May 2012 21:08:21 GMT

Mars,

I think your single-quotes are messing you up.

Try this instead:

Variables:

vF1Type = A,B,C,D <-- Notice, no quotes. None.
vF2Type = Value1,Value2

That might work right away. If not, try this:

Expression:

(Sum( {<Field1={'$(vF1Type)'},Field2={'$(vF2Type)'}>} Sales * [Transaction Quantity])/1000000)

/+ (Sum({<Field1={'$(vF1Type)'},Field2={'Miscellaneous receipt'},Field3={'OUTS'}>} Sales * [Transaction Quantity])/1000000)