topic How to make condition to compare previous value with the current value? in QlikView

How to make condition to compare previous value with the current value?

Tue, 31 Aug 2010 17:38:19 GMT

Hi all,

I want to make if function. And my condition is to compare value in previous dimension with the current value in dimension.

Part No	Status	Production_Order	Issue	Yield
1AH391M04432	Complete	0 1100 00001 75 0	1,152	1,128
1AH391M04432	Complete	0 1100 00001 75 1	1,152	1,124
1AH391M04432	Complete	0 1100 00001 75 2	1,152	1,116

In above table,I want to make expression when Issue in previous Production_Order equal with Issue in current Production_Order.

I try to use "previous" function, but it's not work for me. Can anyone have suggested for this problem?

How to make condition to compare previous value with the current value?

Tue, 31 Aug 2010 17:50:03 GMT

hello..

i hope this can help u

this one is for expresion

yesterday:

Sum ({$<mst_date={"$(=date(max(mst_date)-1))"}>} amount)

current:

Sum ({$<mst_date={"$(=Max(mst_date))"}>} amount)

or u maybe can make a table for yesterday data and a table for current data

How to make condition to compare previous value with the current value?

Miguel_Angel_Baeyens — Tue, 31 Aug 2010 17:52:59 GMT

Hello,

If you are working on an expression, you my use inter-record functions: below(), above(), after()... Take into account the position if you are using a pivot table.

Regards