Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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

5 Replies
Not applicable
Author

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
Author

ya bhanu ,

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


-lohi

aveeeeeee7en
Specialist III
Specialist III

Hi

Try Something like this:

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


You can use this in Script or in Expression.

Regards

Aviral Nag

Not applicable
Author

hi aviral ,

Txs for reply ,

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