topic Re: Formula Help in QlikView

Formula Help

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Please help me to solve this.

=sum({$<dummy={1} $(vQtySubSet) $(vPriceSubSet), Price_Reference_Price_exists = {1}>} InvoicedQuantity)

Re: =sum({$} InvoicedQuantity)

Anonymous — Mon, 05 Nov 2018 06:19:31 GMT

I need explanation for this formula that whether the 3 variables "$<dummy={1}", "$(vQtySubSet)" and "$(vPriceSubSet)" are doing multiplication in this formula or not.

Re: Formula Help

vishsaggi — Mon, 05 Nov 2018 18:42:29 GMT

I doubt it, can you tell us does this expr gives you any result? What are the variable expr inside?

Re: Formula Help

Anil_Babu_Samineni — Tue, 06 Nov 2018 04:28:43 GMT

Expression wrong to me, Perhaps this way?

=sum({$<dummy={"=Only({1} $(vQtySubSet)*$(vPriceSubSet))"}, Price_Reference_Price_exists = {1}>} InvoicedQuantity)

Re: Formula Help

Anonymous — Tue, 06 Nov 2018 06:37:43 GMT

yes it gives us result.

variable expressions are as below

vQtySubSet =If(vQty_Filter = 'On',',InvoicedQuantity = {">$(vQty_Min)<$(vQty_Max)"}',)

vPriceSubSet= If(vPrice_Filter = 'On',',NetPriceLC = {">$(vPrice_Min)<$(vPrice_Max)"}',)

Re: Formula Help

Anonymous — Tue, 06 Nov 2018 06:41:10 GMT

The expression which I have mentioned before, is absolutely correct.Even it is returning the desired result as well.