# New to Qlik Sense

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

Announcements
cancel
Showing results for
Did you mean:
Creator III

## Multiplier Front End (Previous/Current) field

Hi

How can we create a new Field on UI without making any changes on back end script. Month and Value 1 are available. Now user wants to derive Value 2 field as shown below.

Value 2 (Feb) = Jan(Value 1) * Feb(Value 1) = 1.08*1.09 = 1.18

Value 2 (Mar) = Feb(Value 1) * Mar(Value 1) = 1.09*1.04 = 1.13

Value 2 (Apr) = Mar(Value 1) * Apr(Value 1) = 1.04*1.03 = 1.07

 Month Value 1 Value 2 Jan 1.08 Feb 1.09 1.18 Mar 1.04 1.13 Apr 1.03 1.07

Thanks!

Labels (3)

• ### previous month

1 Solution

Accepted Solutions
MVP

Try this

`=Sum(Value1) * Alt(Above(Sum(Value1)), 0)`

or

`=exp(RangeSum(Above(log(Sum(Value1)), 0, 2)))`
2 Replies
MVP

Try this

`=Sum(Value1) * Alt(Above(Sum(Value1)), 0)`

or

`=exp(RangeSum(Above(log(Sum(Value1)), 0, 2)))`
Creator III

Thanks Sunny !

`=Sum(Value1) * Alt(Above(Sum(Value1)), 0)`