topic Problem with variables. in QlikView https://community.qlik.com/t5/QlikView/Problem-with-variables/m-p/241533#M91947 <HTML><HEAD></HEAD><BODY><P><SPAN closure_uid_e33ksr="444" style="background-color: #fff;" tc="Olá," uc="Hello,">Hello,<BR /><BR /></SPAN><SPAN closure_uid_e33ksr="445" style="background-color: #fff;" tc="Estou com um problema em uma expressão/variável que não consigo resolver." uc="I have a problem in an expression / variable that can not solve.">I have a problem in an expression / variable that can not solve.<BR /></SPAN> <SPAN closure_uid_e33ksr="446" tc="Criei duas variáveis:" uc="I created two variables:">I created two variables:<BR /><BR /></SPAN><SPAN closure_uid_e33ksr="447" tc="1ª" uc="1st">1st<BR /></SPAN><SPAN closure_uid_e33ksr="448" tc="IF (Ajuste = 'Com Ajuste'," uc="IF (= Set 'On Set'">IF (= Set 'On Set'<BR /></SPAN><SPAN closure_uid_e33ksr="449" style="background-color: #fff;" tc="SUM((VENDA_DESC*Quant_Pçs)" uc="SUM ((* VENDA_DESC Quant_Pçs)">SUM ((* VENDA_DESC Quant_Pçs)<BR /></SPAN><SPAN closure_uid_e33ksr="450" style="background-color: #fff;" tc="*IF( ISNULL(Ajuste_Venda)OR Ajuste_Venda = 0 ,1,Ajuste_Venda))," uc="* IF (ISNULL (Ajuste_Venda) OR Ajuste_Venda = 0, 1, Ajuste_Venda)),">* IF (ISNULL (Ajuste_Venda) OR Ajuste_Venda = 0, 1, Ajuste_Venda)),<BR /></SPAN><SPAN closure_uid_e33ksr="451" style="background-color: #fff;" tc="SUM((VENDA_DESC*Quant_Pçs)))" uc="SUM ((VENDA_DESC Quant_Pçs *)))">SUM ((VENDA_DESC Quant_Pçs *)))<BR /><BR /></SPAN><SPAN closure_uid_e33ksr="452" tc="2ª" uc="2nd">2nd<BR /></SPAN><SPAN closure_uid_e33ksr="453" style="background-color: #fff;" tc="IF(Ajuste = 'Com Ajuste',sum(CSU_COM_AJUSTE*Quant_Pçs),sum(CSU_SEM_AJUSTE*Quant_Pçs))" uc="IF (= Set 'On Set', sum (CSU_COM_AJUSTE Quant_Pçs *), sum (CSU_SEM_AJUSTE Quant_Pçs *))">IF (= Set 'On Set', sum (CSU_COM_AJUSTE Quant_Pçs *), sum (CSU_SEM_AJUSTE Quant_Pçs *))<BR /><BR /></SPAN><SPAN closure_uid_e33ksr="454" tc="Quando utilizo essas variáveis dentro de uma expressão da seguinte forma elas funcionam:" uc="When I use these variables within an expression they work as follows:">When I use these variables within an expression they work as follows:<BR /><BR /></SPAN><SPAN closure_uid_e33ksr="455" tc="=$(1ª) - $(2ª)" uc="= $ (1st) - $ (2nd)">= $ (1st) - $ (2nd)<BR /><BR /></SPAN><SPAN closure_uid_e33ksr="456" tc="Mais se acrescento parenteses entre elas não traz nenhum resultado:" uc="But if I add parentheses between them does not bring any results:">But if I add parentheses between them does not bring any results:<BR /><BR /></SPAN><SPAN closure_uid_e33ksr="459" tc="=($(1ª) - $(2ª))" uc="= ($ (1st) - $ (2nd))">= ($ (1st) - $ (2nd))<BR /><BR /></SPAN>Can anyone help?</P></BODY></HTML> Wed, 04 Aug 2010 15:33:17 GMT Anonymous 2010-08-04T15:33:17Z Problem with variables. https://community.qlik.com/t5/QlikView/Problem-with-variables/m-p/241533#M91947 <HTML><HEAD></HEAD><BODY><P><SPAN closure_uid_e33ksr="444" style="background-color: #fff;" tc="Olá," uc="Hello,">Hello,<BR /><BR /></SPAN><SPAN closure_uid_e33ksr="445" style="background-color: #fff;" tc="Estou com um problema em uma expressão/variável que não consigo resolver." uc="I have a problem in an expression / variable that can not solve.">I have a problem in an expression / variable that can not solve.<BR /></SPAN> <SPAN closure_uid_e33ksr="446" tc="Criei duas variáveis:" uc="I created two variables:">I created two variables:<BR /><BR /></SPAN><SPAN closure_uid_e33ksr="447" tc="1ª" uc="1st">1st<BR /></SPAN><SPAN closure_uid_e33ksr="448" tc="IF (Ajuste = 'Com Ajuste'," uc="IF (= Set 'On Set'">IF (= Set 'On Set'<BR /></SPAN><SPAN closure_uid_e33ksr="449" style="background-color: #fff;" tc="SUM((VENDA_DESC*Quant_Pçs)" uc="SUM ((* VENDA_DESC Quant_Pçs)">SUM ((* VENDA_DESC Quant_Pçs)<BR /></SPAN><SPAN closure_uid_e33ksr="450" style="background-color: #fff;" tc="*IF( ISNULL(Ajuste_Venda)OR Ajuste_Venda = 0 ,1,Ajuste_Venda))," uc="* IF (ISNULL (Ajuste_Venda) OR Ajuste_Venda = 0, 1, Ajuste_Venda)),">* IF (ISNULL (Ajuste_Venda) OR Ajuste_Venda = 0, 1, Ajuste_Venda)),<BR /></SPAN><SPAN closure_uid_e33ksr="451" style="background-color: #fff;" tc="SUM((VENDA_DESC*Quant_Pçs)))" uc="SUM ((VENDA_DESC Quant_Pçs *)))">SUM ((VENDA_DESC Quant_Pçs *)))<BR /><BR /></SPAN><SPAN closure_uid_e33ksr="452" tc="2ª" uc="2nd">2nd<BR /></SPAN><SPAN closure_uid_e33ksr="453" style="background-color: #fff;" tc="IF(Ajuste = 'Com Ajuste',sum(CSU_COM_AJUSTE*Quant_Pçs),sum(CSU_SEM_AJUSTE*Quant_Pçs))" uc="IF (= Set 'On Set', sum (CSU_COM_AJUSTE Quant_Pçs *), sum (CSU_SEM_AJUSTE Quant_Pçs *))">IF (= Set 'On Set', sum (CSU_COM_AJUSTE Quant_Pçs *), sum (CSU_SEM_AJUSTE Quant_Pçs *))<BR /><BR /></SPAN><SPAN closure_uid_e33ksr="454" tc="Quando utilizo essas variáveis dentro de uma expressão da seguinte forma elas funcionam:" uc="When I use these variables within an expression they work as follows:">When I use these variables within an expression they work as follows:<BR /><BR /></SPAN><SPAN closure_uid_e33ksr="455" tc="=$(1ª) - $(2ª)" uc="= $ (1st) - $ (2nd)">= $ (1st) - $ (2nd)<BR /><BR /></SPAN><SPAN closure_uid_e33ksr="456" tc="Mais se acrescento parenteses entre elas não traz nenhum resultado:" uc="But if I add parentheses between them does not bring any results:">But if I add parentheses between them does not bring any results:<BR /><BR /></SPAN><SPAN closure_uid_e33ksr="459" tc="=($(1ª) - $(2ª))" uc="= ($ (1st) - $ (2nd))">= ($ (1st) - $ (2nd))<BR /><BR /></SPAN>Can anyone help?</P></BODY></HTML> Wed, 04 Aug 2010 15:33:17 GMT https://community.qlik.com/t5/QlikView/Problem-with-variables/m-p/241533#M91947 Anonymous 2010-08-04T15:33:17Z