topic Re: Values change when you select the product in QlikView

Values change when you select the product

fftec_fftec — Sat, 16 Nov 2024 00:29:46 GMT

Hello people,

I have a table in QlikView with the dimension Product and the expression stock.

when selecting any product the stock value changes.

I will list the example here

== Expression I'm using ==

IF(PRODUTO.B1_PRV1 = 0,

sum(PRODUTO.QATU_REAL * (PRODUTO.B1_UPRCDOL * vFator )) ,

sum(PRODUTO.QATU_REAL * (PRODUTO.B1_PRV1 * ((100 - vDescontoMedioTipo)/100 )))
)

Before selecting the product

After selecting the product

Re: Values change when you select the product

agigliotti — Thu, 11 Jun 2020 13:24:03 GMT

maybe this:

=sum(
if( PRODUTO.B1_PRV1 = 0, ( PRODUTO.QATU_REAL * (PRODUTO.B1_UPRCDOL * vFator ) ),
( PRODUTO.QATU_REAL * (PRODUTO.B1_PRV1 * ((100 - vDescontoMedioTipo)/100 )) )
)
)

I hope it can helps.

Re: Values change when you select the product

fftec_fftec — Thu, 11 Jun 2020 14:20:26 GMT

Unfortunately it didn't. Do you have any other tips to help me?

Re: Values change when you select the product

fftec_fftec — Sat, 13 Jun 2020 15:11:29 GMT

The problem was in the variable vFator.
Thank you!