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

Previous value and current value in stright table.

Hi All,

I have scenario in which i have to calculate % of current value to the previous value in a stright table. Expecting last coulmn result in the below table.

 

Value1Dim-80000.0
Value2Dim-50000.6
Value3Dim-30000.6
Value4Dim-10590.4
Value5Dim-10000.9
Value6Dim5000-5.0
Value7Dim150593.0
Value8Dim158641.1
Value9Dim261361.6
Value10Dim810003.1
Value11Dim1250001.5

Expression Plzzzzz. I tried with above(below(coulmn(2)/coulmn(2))) which

Thanks in Advance!!!

5 Replies
Anonymous
Not applicable

You are talking about Current Year Value & Previous Year Value??

Pls Share the sample data, else you can write a expression to calculate %

Say: Current Year Data Expression/Previous Year Data Expression and then in number format, change the format

of this expression into Percent(%).

Hope this will help...

Not applicable

Hi,

In the above table can you tell me which is the current value and which is the previous value.

manojkulkarni
Partner - Specialist II
Partner - Specialist II

CurrentExp/(Above(CurrentExp)-1

CurrentExp = is you expression for column(2)

jonathandienst
Partner - Champion III
Partner - Champion III

I think you just need

=Column(2) / Above(Column(2))

In the Properties | Numbers tab, select % format

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
SreeniJD
Specialist
Specialist

Hari,

Can you pls give me more clarity on this request

Sreeni