Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
sibideepak
Creator II
Creator II

doubt in before function

Hi all,

I have an pivot table with data shown in image

but what i actually want is i want add another expression that sums before column ie

Q1                 Q2                       Q3               Q4

val1 val2    val1 val2           val1 val2         val1  val2

6      6         7      13              8      21           5       26

Thanks in advance

6 Replies
sibideepak
Creator II
Creator II
Author

is anyone to reply !!!

CELAMBARASAN
Partner - Champion
Partner - Champion

PFA

I hope it will help you

tresesco
MVP
MVP

val1=Sum(AmtField)

val2=RangeSum(Before(Sum(AmtField),0,2))

sibideepak
Creator II
Creator II
Author

Hi ,

In both peoples answer ..im not getting it..

here is my sample file

CELAMBARASAN
Partner - Champion
Partner - Champion

Sorry !

Exp2 shoud be =Alt(Before(Exp2), 0) + Exp1

sibideepak
Creator II
Creator II
Author

Hi ,

is this achievable from script or using variable because i dont want it in front end