topic If expression in Text Object in QlikView

If expression in Text Object

paulopereiraqv — Wed, 28 Oct 2020 13:14:05 GMT

The result of this expression is equal to zero but whwn i do an IF expression in a Text Object the result is different than Zero. Can someone help me with this. Thanks.

Qtd1 = 10

Qtd2 = 10

Qtd1 - Qtd2 = 0

=If(num(Sum( {< PromoOpor = PromocoesWISE::PromoOpor, DateWise = PromocoesWISE::DateWise >} Qtd1) -
Sum( {< Promo = PromocoesSAP::Promo,Date = PromocoesSAP::Date >} Qtd2), '#,##0.00') = 0, 1, 0)

Re: If expression in Text Object

marcus_sommer — Thu, 29 Oct 2020 13:34:12 GMT

Quite probably are the results of Qtd1 and Qtd2 not absolutely identically. Try it with the following change:

=If(round(Sum( {< ... >} Qtd1), 0.01) - round(Sum( {< ... >} Qtd2), 0.01) = 0, 1, 0)

- Marcus

Re: If expression in Text Object

paulopereiraqv — Sun, 01 Nov 2020 22:31:40 GMT

Thanks Marcus. You save my Day.