Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Contributor 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!!!

Tags (1)
5 Replies
Highlighted
Esteemed Contributor

Re: Previous value and current value in stright table.

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...

Highlighted
Not applicable

Re: Previous value and current value in stright table.

Hi,

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

Highlighted
Partner
Partner

Re: Previous value and current value in stright table.

CurrentExp/(Above(CurrentExp)-1

CurrentExp = is you expression for column(2)

Highlighted
MVP
MVP

Re: Previous value and current value in stright table.

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
Highlighted
Valued Contributor

Re: Previous value and current value in stright table.

Hari,

Can you pls give me more clarity on this request

Sreeni