Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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