topic Re: expression to calculate discount in QlikView

expression to calculate discount

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

Hi All,

Following is the expression to calculate discount%. Its giving wrong value

Here sales value is without tax

=((sum({stateA< Year = {"$(=Max(Year)-2)"}>} quantity_sold * MRP_INR)

- sum({stateA< Year = {"$(=Max(Year)-2)"}>} quantity_returns * MRP_INR))

( sum({stateA< Year = {"$(=Max(Year)-2)"}>} [sales value])))

(sum({stateA< Year = {"$(=Max(Year)-2)"}>} quantity_sold * MRP_INR)

- sum({stateA< Year = {"$(=Max(Year)-2)"}>} quantity_returns * MRP_INR))

Re: expression to calculate discount

PrashantSangle — Thu, 15 Mar 2018 06:20:04 GMT

Hi,

can you explain little bit more.

how your data look like?

why are u using alternate state?

what is the expected output?

what challenges are you facing?

Regards,

Re: expression to calculate discount

Anonymous — Thu, 15 Mar 2018 06:32:34 GMT

Here under discount column I am getting higher value as expected and I am using three different multibox for current year, previous year and before previous year