Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
BI & Data Trends 2021. Discover the top 10 trends emerging in today. Join us on Dec. 8th REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
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
Highlighted
Partner
Partner

Hi @Baldaia 

Try:

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

Regards,

Mauritz

View solution in original post

Highlighted
Contributor II
Contributor II

Just perfect!

thank you