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
Creator III
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

MonthValue 1Value 2
Jan1.08 
Feb1.091.18
Mar1.041.13
Apr1.031.07

 

Thanks!

Labels (3)
1 Solution

Accepted Solutions
Highlighted

Try this

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

or

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

View solution in original post

2 Replies
Highlighted

Try this

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

or

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

View solution in original post

Highlighted
Creator III
Creator III

Thanks Sunny !

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