topic Previous value and current value in stright table. in QlikView

Previous value and current value in stright table.

hariprasadqv — Fri, 18 Sep 2015 06:32:35 GMT

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.

Value1	Dim	-8000	0.0
Value2	Dim	-5000	0.6
Value3	Dim	-3000	0.6
Value4	Dim	-1059	0.4
Value5	Dim	-1000	0.9
Value6	Dim	5000	-5.0
Value7	Dim	15059	3.0
Value8	Dim	15864	1.1
Value9	Dim	26136	1.6
Value10	Dim	81000	3.1
Value11	Dim	125000	1.5

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

Thanks in Advance!!!

Re: Previous value and current value in stright table.

Anonymous — Fri, 18 Sep 2015 06:39:39 GMT

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

Re: Previous value and current value in stright table.

Fri, 18 Sep 2015 06:39:44 GMT

Hi,

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

Re: Previous value and current value in stright table.

manojkulkarni — Fri, 18 Sep 2015 06:40:06 GMT

CurrentExp/(Above(CurrentExp)-1

CurrentExp = is you expression for column(2)

Re: Previous value and current value in stright table.

jonathandienst — Fri, 18 Sep 2015 06:49:58 GMT

I think you just need

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

In the Properties | Numbers tab, select % format

Re: Previous value and current value in stright table.

SreeniJD — Tue, 20 Oct 2015 11:14:32 GMT

Hari,

Can you pls give me more clarity on this request

Sreeni