topic Re: Need front end logic help to write expression. in QlikView

Need front end logic help to write expression.

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

Hi,

With attached data I want to calculate incentive on the basis of sales achievement.

Please help me out to wright the expression on front end.

Incentive calculation :-

if Sales Achievement <90 then 0

if Sales Achievement >=90 and <95 then (0.90% of Sale)

if Sales Achievement >=95 and <100 then (1.00 % of Sale)

if Sales Achievement >100 and <110 then (1.25 % of Sale)

if Sales Achievement >110 then (1.35% of Sale)

awhitfield — Mon, 27 Mar 2017 10:47:18 GMT

Hi See attached rough and ready example

Should get you started

HTH

Andy

Anil_Babu_Samineni — Mon, 27 Mar 2017 10:49:58 GMT

May be this?

if([Sales Achievement] <90, 0,

if([Sales Achievement] >=90 and [Sales Achievement]<95, Sum(Sale)*0.9,

if([Sales Achievement] >=95 and [Sales Achievement]<100, Sum(Sale)*1,

if([Sales Achievement] >100 and [Sales Achievement]<110, Sum(Sale)*1.25,

if([Sales Achievement] >110, Sum(Sale)*1.35)))))

lalitkgehlot89 — Mon, 27 Mar 2017 10:52:37 GMT

thanks a lot Andrew.

lalitkgehlot89 — Mon, 27 Mar 2017 10:55:53 GMT

thanks a lot anil.