Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Save $650 on Qlik Connect, Dec 1 - 7, our lowest price of the year. Register with code CYBERWEEK: Register
cancel
Showing results for 
Search instead for 
Did you mean: 
Baldaia
Contributor II
Contributor II

sum value with a percentage of it

Hi,

i want to sum a value to 10% of it, like this

[Target] + 10% of [Target]

How i do that?

 

Then i will compare it to another value like this:

 

If([x] <= [Target], '1',
If([x] <= ([Target] + 10% of [Target]), '2',
'3'))

thx

Labels (1)
1 Solution

Accepted Solutions
Mauritz_SA
Partner - Specialist
Partner - Specialist

Hi @Baldaia 

Try:

If([x] <= [Target], '1', If([x] <= ([Target]*1.1), '2','3'))

Regards,

Mauritz

View solution in original post

2 Replies
Mauritz_SA
Partner - Specialist
Partner - Specialist

Hi @Baldaia 

Try:

If([x] <= [Target], '1', If([x] <= ([Target]*1.1), '2','3'))

Regards,

Mauritz

Baldaia
Contributor II
Contributor II
Author

Just perfect!

thank you