Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Scripting in back end

hi QVs,

I have a table like this

At Commission 2% it should take "5999" instead of "105999" , how to do that ?

-lohi

Tags (2)
5 Replies
Not applicable

Re: Scripting in back end

could you make it little more clear because in the image i do see 2.0% but u have mentioned as 0.2%.so, do provide an sample qvw app

Not applicable

Re: Scripting in back end

ya bhanu ,

At Commission 2% it should take "5999" instead of "105999" , how to do that ?


-lohi

MVP
MVP

Re: Scripting in back end

aveeeeeee7en
Valued Contributor III

Re: Scripting in back end

Hi

Try Something like this:

If(Commission='2%','5999',CumulativeSum)


You can use this in Script or in Expression.

Regards

Aviral Nag

Not applicable

Re: Re: Scripting in back end

hi aviral ,

Txs for reply ,

But it taking all 2% =5999 form there it shoud be cumilative sum .