topic expression in the script in QlikView

expression in the script

adiarnon — Tue, 19 Jul 2016 06:49:02 GMT

hi,

i have a inline table that i need to use the _Measure in my model as a expression-

i added a text box with = _Measure and its giving me the text and not the resault of the expression

[_VIEW_N,_Measure

1,num(SUM(USD_AMNT_BY_PO_RATE)/1000,'#,##0')

2,num(count( ORDER_NO),'#,##0')

3,num(count(distinct ORDER_NO),'#,##0')

4,num(count(distinct BUYER_NAME),'#,##0')

5,num(count(distinct BP_CODE_CB),'#,##0') ];

what can i do?

adi

Tue, 19 Jul 2016 06:50:23 GMT

$(=_Measure)

Mark_Little — Tue, 19 Jul 2016 07:21:06 GMT

HI,

You need to dollar expand as mentioned above.

If you call as you do you are asking for what is inside the variable i.e. the string for your formula.

When you dollar expand $(_measure) you are asking for the results of your formula.

Mark