Using input value for projection

300sss300 — Wed, 25 Nov 2020 16:16:04 GMT

HI,

suppose I have following 04 data fields

1. Purchased Quantity (PQ), 2. Purchased Value (PV), 3. Sale QTY (SQ) & Sale Value (SV)

now lets say Sum(PQ) = 100 and Sum(PV) = 1,000

till date sum(SQ)=40, & Sum(SV)=600

I wanna use any Sale price as input which should show me margin above PV after multiplying with remaining PQ (60)

For example:

when the input value is 20 it should auto calculate projected margin above PV(1000) as in this case Input value*(Sum(PQ)-Sum(SQ))+Sum(SV)-Sum(PV) if it is 20 then output should be 1000(20*60+800-1000)

How to link this input value to an expression in a straight table or text box or a button so that when I change the value it should show the result for my projected Margin based on remaining QTY.

Thanks

Re: Using input value for projection

dplr-rn — Tue, 15 Jan 2019 02:56:39 GMT

Did you try to Declare and use a variable e.g. vInputValue use this in input box

Your expression can be
vInputValue*(Sum(PQ)-Sum(SQ))+Sum(SV)-Sum(PV)

Hope I understood the issue correctly

Re: Using input value for projection

300sss300 — Tue, 15 Jan 2019 12:14:12 GMT

Thanks

topic Using input value for projection in QlikView

Using input value for projection

Re: Using input value for projection

Re: Using input value for projection