Find last serious value in the expression

jagannalla — Tue, 18 Sep 2012 18:42:56 GMT

Hello,

I've three columns in my table those are Dim, Value, Flag. Now I've taken Dim as dimension in ST with 12 expression as shown in below image.

- Each expression is ploting based on Flag value.

For eg:

Flag =1, 1st Qtr

Flag =2, 2nd Qtr

Flag =7, July

Flag =8, Aug

.....

Flag =12,Dec

- Now In 13th expression (i.e. Trend) I need like this.

I need to find the last value of the serious values in the expression and it should be compared with previous serious value expresssion. If last value greater than the previous value the arrow should up otherwise down.

For eg:

In LPH serious the last value is for Sept. Now the expression should be If (Sept > Oct, UParrow, Downarrow)

In Z17 serous the last value is for Dec, Now the expression shoul be If(Dec > Nov, Uparrow, Downarrow)

right now the trend value if ploting based on expression If(Sept > Aug, Uparrow,Downarrow)

How can i achive this.

topic Find last serious value in the expression in QlikView

Find last serious value in the expression