topic (1- Discount)? in QlikView

(1- Discount)?

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

Hi There,

Sorry for the basic question. I wonder what does 1-Discount indicate in the below calculated field. Can we write this in some other way. Please explain.

Quantity * UnitPrice * (1- Discount) as LineSalesAmount

Thanks!!

Re: (1- Discount)?

hector_munoz — Sun, 26 Mar 2017 14:42:31 GMT

Hi Suraj,

It seeme that Discount field has information about % of discount in a product. For example, 20 shirts with a price of 10 € and a discount of 10% will result: 20 * 10 * (1 - 0.2) = 180 €.

Hope it serves...

Regards,

Re: (1- Discount)?

surajap123 — Sun, 26 Mar 2017 14:50:02 GMT

Thanks for reply.

Sorry, still not clear about (1 - 0.2)

Re: (1- Discount)?

stonecold111 — Sun, 26 Mar 2017 14:54:17 GMT

discount generally in 10% or 20% like that

i mean 0.10 and 0.20 discount

when you calcute (1-discount) and multiply with quantity and unit price

it will give total price of of quantity (whatever product it may be) after removing discount amount

Ex: if you have 10 pens unit price 2 rs and discount 0.10

then 10*2*(1-0.10)=18 rs so discount is 2 rs for all pens

formulae is correct i don't know what you want to change in that formulae

Re: (1- Discount)?

hector_munoz — Sun, 26 Mar 2017 15:00:21 GMT

Exactly

Re: (1- Discount)?

surajap123 — Sun, 26 Mar 2017 15:31:32 GMT

Thanks for explanation.

Now i understand that 0.20 is 20% discount. What does '1-' indicate in (1-discount)

Re: (1- Discount)?

stonecold111 — Sun, 26 Mar 2017 15:39:51 GMT

yey ... if 0.20 is 20% what 1-0.20 will become

will be 80%..what u do you want man. just use that formulae . it will work fine

Re: (1- Discount)?

Anil_Babu_Samineni — Sun, 26 Mar 2017 15:48:03 GMT

Yes, You can write like below

Load Quantity, UnitPrice, Discount, Quantity * UnitPrice * (1- Discount) as LineSalesAmount;

Load * Inline [

Quantity, UnitPrice, Discount

10, 20, 30

];

So the condition works as 10*20*(1-30) = 200 * -29 = -580

Finally Output seems this

Quantity, UnitPrice, Discount, LineSalesAmount

10, 20, 30, -580