topic How can we get a previous field values from a field? in QlikView

How can we get a previous field values from a field?

sridhar423 — Mon, 16 Feb 2015 10:49:41 GMT

Hi All,

I have a table name Quarter with field values Q 1, Q 2, Q 3, Q 4. If i select the Q 4 i should get Q 3 ,if i select Q 3 i should get Q 2,if i select Q 1 i should get Q 4.

Please anyone can help me out from this.

Thanks In advance,

Sridhar.

Re: How can we get a previous field values from a field?

sunny_talwar — Mon, 16 Feb 2015 10:56:48 GMT

You can use Above/Below function to achieve what you are trying to do.

HTH

Best,

Re: How can we get a previous field values from a field?

maxgro — Mon, 16 Feb 2015 11:11:31 GMT

try the attachment

Re: How can we get a previous field values from a field?

jonathandienst — Mon, 16 Feb 2015 11:13:12 GMT

I usually add a month sequence field to deal with the same problem with months. A QuarterSequence would be like this:

LOAD ...

Ceil(Month(Date) / 3) As Quarter,

(Year(Date) * 4) + Ceil(Month(Date) / 3) As QuarterSequence,

...

If you select a Quarter, then Max(QuarterSequence) - 1 will reference the previous quarter. You could use this in a set expression like:

Sum({<QuarterSequence = {"$(=Max(QuarterSequence) - 1)"}>} ....)

If you are trying to do this in a table/chart with Quarter as a dimension, then Above() or Above(Total ) would be a better option as the set expression will not work in this context.

HTH

Jonathan