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: 
psk180590
Creator III
Creator III

Generate a Number from Another Number and a % Value

Hello All,

I have the following requirement

Actual Value%Desired ValueDifference
80080 %1000200
10083 %12020
770 %103
550 %10 5

I would like to generate 'Desired Value' and  'Difference' using Actual Value and %

TIA

Sai.

1 Solution

Accepted Solutions
tresesco
MVP
MVP

It seems to be a simple math, like:

Value*100/PurgeChar(Percent, '%') as Desired

View solution in original post

1 Reply
tresesco
MVP
MVP

It seems to be a simple math, like:

Value*100/PurgeChar(Percent, '%') as Desired