topic Re: Logic Help in QlikView

Logic Help

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

Hi All,

i need some help in logic,

data is

Field1	Field2	Amount	output

SMELAP	assign	100	120	assign90= means 90 % of amount
SMELAP-ASSIGN	assign90	200	180
SMEWC-ASSIGN	assign	300	300

order of field 1 can be different, please suggest

Re: Logic Help

rahulpawarb — Mon, 20 Mar 2017 10:38:36 GMT

Hello Abhay,

Trust that you are doing well!

As per my understanding you want to produce an output field based Field2 values. When Field2 is assign then produce 100% of amount; when it is assign90 then produce output as 90% of amount. Please correct me if I am wrong.

Regards!

Rahul

Re: Logic Help

kkkumar82 — Mon, 20 Mar 2017 10:48:16 GMT

Can you brief your requirement, what are you looking for in the table

Re: Logic Help

abhaysingh — Mon, 20 Mar 2017 12:51:57 GMT

Hi Rahul,

Thanks

Yes you are correct, adding one point, when assigned90 then rest 10% should be club in SMELAP, in data first row, u can see 100 become 120 in output.

Regards

Abhay