topic Variable not accept brackets. in QlikView

Variable not accept brackets.

Anonymous — Wed, 29 Dec 2010 19:07:36 GMT

Hello.

I have a variable that has the following syntax:

if($(VR_PZ_Médio_Entrega)<30,(sum(VENDAS_MES_ANTERIOR1)/(avg((Dias_Uteis_Anterior)))*(avg((Dias_Uteis_Atuais)) )*(1+$(VR_simulador_quant_venda))),

$(VR_PZ_Médio_Entrega)*((sum(VENDAS_MES_ANTERIOR1)/(avg((Dias_Uteis_Anterior)))*(avg((Dias_Uteis_Atuais)) )*(1+$(VR_simulador_quant_venda)))/30))

And her name is:

$(VR_Reposição_Quant_Venda_Prevista)

Now, if I put parenthesis between the variable, it does not bring value.

($(VR_Reposição_Quant_Venda_Prevista) )

--------------------------------------------------------------

Syntax brings the value of a field and divide by the number of working days in the previous month and multiply by the amount of days of current month.

Variable not accept brackets.

pover — Wed, 29 Dec 2010 19:16:33 GMT

What happens if you put the parentheses directly in the variable?

(

if($(VR_PZ_Médio_Entrega)<30,(sum(VENDAS_MES_ANTERIOR1)/(avg((Dias_Uteis_Anterior)))*(avg((Dias_Uteis_Atuais)) )*(1+$(VR_simulador_quant_venda))),

$(VR_PZ_Médio_Entrega)*((sum(VENDAS_MES_ANTERIOR1)/(avg((Dias_Uteis_Anterior)))*(avg((Dias_Uteis_Atuais)) )*(1+$(VR_simulador_quant_venda)))/30))

)

Regards.

Variable not accept brackets.

Anonymous — Wed, 29 Dec 2010 19:33:35 GMT

Do not bring any value ....

Variable not accept brackets.

pover — Wed, 29 Dec 2010 19:51:17 GMT

If you are using this variable to divide something, make sure the second $(VR_PZ_Médio_Entrega) is not 0 because that seems to be the only part of the formula that would be affected by adding parentheses.

Regards.

Variable not accept brackets.

Anonymous — Wed, 29 Dec 2010 20:06:14 GMT

The variable (VR_PZ_Médio_Entrega) has value. Interesting is that if I leave the formula just = sum (VENDAS_MES_ANTERIOR1) it goes right to the same variable in parentheses. I took the formula the amount of previous days (avg ((Dias_Uteis_Anterior))) and current days avg ((Dias_Uteis_Atuais))). When I delete these two variables in the expression of my right. In variable (avg ((Dias_Uteis_Anterior))) the result is 22 and avg ((Dias_Uteis_Atuais))) is 23. If I replace my variable in the field by the expression, the result also of the right.

Variable not accept brackets.

pover — Wed, 29 Dec 2010 20:14:55 GMT

Maybe QV doesn't like that you are nesting $($()). It might work if you put a = before the if() in the variable, but you might not get the result you want.

Regards.

Variable not accept brackets.

Anonymous — Wed, 29 Dec 2010 20:15:39 GMT

Further simplified my expression but still not bringing anything.
= sum (VENDAS_MES_ANTERIOR1) / avg ($ (Dias_Uteis_Anterior)).

If I make a variable with the expression above and take it to a field, does not work.

But if I take the full expression for the field she works.

I see it is a problem as that term is mounted in the variable.

Variable not accept brackets.

Anonymous — Wed, 29 Dec 2010 20:41:04 GMT

Another test I did was create another variable with the following expression: sum (VENDAS_MES_ANTERIOR1) / avg (NETWORKDAYS (MonthStart (AddMonths (today (),(- 1))), MonthsEnd (1, 1 )))). (),(- Today The variable name is: $ (VR_Reposição_Quant_Venda_Prevista). If within a column esso use the variable up that way, = $ (VR_Reposição_Quant_Venda_Prevista), she brings me the result. More to do as follows, = ($ (VR_Reposição_Quant_Venda_Prevista)) with the parenthesis it gives error. I'll need to have the relatives as the result of this variable with other fields will be used for other calculations. eg = ($ (VR_Reposição_Quant_Venda_Prevista) + A)-B / C.