# New to Qlik Sense

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

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for
Did you mean:
Creator

## I need your help with a formula to put a limit in a field

For example, if I have a field "natural" with value 12, the limit is 9, so in double filed  write 9, and the rest write in another field triple, with value 3.

hours:

employee, natural, double, triple

1, 8, 8, 0

2, 9, 9, 0

3, 11, 9, 2

4, 12, 9, 3

5, 13, 9, 4

6, 10, 9, 1

7, 11, 9, 2

8, 15, 9, 6

9, 11, 9, 2

];

how can I do something like this example, since I only have the natural field?

1 Solution

Accepted Solutions
MVP

Maybe like

hours:

employee, natural, double, triple

1, 8, 8, 0

2, 9, 9, 0

3, 11, 9, 2

4, 12, 9, 3

5, 13, 9, 4

6, 10, 9, 1

7, 11, 9, 2

8, 15, 9, 6

9, 11, 9, 2

];

5 Replies
MVP

Maybe like

hours:

employee, natural, double, triple

1, 8, 8, 0

2, 9, 9, 0

3, 11, 9, 2

4, 12, 9, 3

5, 13, 9, 4

6, 10, 9, 1

7, 11, 9, 2

8, 15, 9, 6

9, 11, 9, 2

];

Champion III

hello Erick,

This is duplicate thread. Can you close this marking Stefans response correct/helpful, so that it helps other members save their time.

Thanks
V.

Specialist II
Creator
Author

It works, but I use this:

natural,

rangemin(natural,9) as double,

natural-rangemin(natural,9) as triple,

rangemin(natural,9)+(natural-rangemin(natural,9)) as result

INLINE [

employee, natural

1, 8

2, 9

3, 11

4, 12

5, 13

6, 10

7, 11

8, 13

9, 14

10,15

11,16

12,17

13,18

14,19

15,20

16,21

];

Creator
Author

Ok, thank you.

Tags
Community Browser