Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Welcome to our newly redesigned Qlik Community! Read our blog to learn about all the new updates: READ BLOG and REPORTED ISSUES
cancel
Showing results for 
Search instead for 
Did you mean: 
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 (3)
1 Solution

Accepted Solutions
Partner
Partner

Hi @Baldaia 

Try:

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

Regards,

Mauritz

View solution in original post

2 Replies
Partner
Partner

Hi @Baldaia 

Try:

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

Regards,

Mauritz

View solution in original post

Contributor II
Contributor II

Just perfect!

thank you