topic How to calculate Discount Value in QlikView

How to calculate Discount Value

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

Hello everyone,

i need to calculate only discount value from total sales value.

i am not getting how to write expression.

Thank You.

woshua5550 — Tue, 14 Nov 2017 08:57:55 GMT

Hi prachi

plz provide some sample data

arvind_patil — Tue, 14 Nov 2017 09:12:38 GMT

Hi Prachi,

Formula May be like this:

Sum(Sales)*Discount Percenteage/100

So Suppose Your Sales =100,

Discount Percentage= 10%

100*10/100=10

Thanks,
Arvind Patil

Anonymous — Tue, 14 Nov 2017 09:13:40 GMT

I need to calculate discount value(for eg. second row sales value is 3709.395 and discount 10% so want to find discount value)

Anonymous — Tue, 14 Nov 2017 09:18:05 GMT

i have different discount like

woshua5550 — Tue, 14 Nov 2017 09:24:25 GMT

I think this is fine

=Sum(Sales * Discount)

sumanta12 — Tue, 14 Nov 2017 13:11:21 GMT

Please try with this

SUM(SALES)*SUM(DISCOUNT)

Mark_Little — Tue, 14 Nov 2017 14:30:34 GMT

Hi,

I think your willl the issue is with the discount field, if it shows as 10% it will be dealing with it as a string.

Either in Script add

NUM(PURGECHAR(Discount,'%')) AS DiscountNum

Or in the set analysis

SUM(Sale*NUM(PURGECHAR(Discount,'%')))

Mark