Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Problem with variables.

Hello,

I have a problem in an expression / variable that can not solve.
I created two variables:

1st
IF (= Set 'On Set'
SUM ((* VENDA_DESC Quant_Pçs)
* IF (ISNULL (Ajuste_Venda) OR Ajuste_Venda = 0, 1, Ajuste_Venda)),
SUM ((VENDA_DESC Quant_Pçs *)))

2nd
IF (= Set 'On Set', sum (CSU_COM_AJUSTE Quant_Pçs *), sum (CSU_SEM_AJUSTE Quant_Pçs *))

When I use these variables within an expression they work as follows:

= $ (1st) - $ (2nd)

But if I add parentheses between them does not bring any results:

= ($ (1st) - $ (2nd))

Can anyone help?

0 Replies