Discussion Board for collaboration related to QlikView App Development.
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.
Expression Plzzzzz. I tried with above(below(coulmn(2)/coulmn(2))) which
Thanks in Advance!!!
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...
In the above table can you tell me which is the current value and which is the previous value.
CurrentExp = is you expression for column(2)
I think you just need
=Column(2) / Above(Column(2))
In the Properties | Numbers tab, select % format
Can you pls give me more clarity on this request