topic Re: Previous Value in QlikView

Previous Value

soha1902 — Mon, 17 Aug 2015 10:46:59 GMT

Hi All,

I have one "FiscalYearNumber" List Box, contains the following values:

41091

41456

41821

42186

I am writing one expression where I need to select less then value of selected value. For example If 42186 selected then I need to pick 41821. If 41456 selected then 41091 will be select.

How I write expression to do this?

Thanks

Re: Previous Value

MK_QSL — Mon, 17 Aug 2015 10:49:46 GMT

You need to assign the same in script as previous flag...

Data:

Load * Inline

[

FiscalYearNumber

41091

41456

41821

42186

];

Left Join

Load FiscalYearNumber, Peek('FiscalYearNumber') as PreviousFiscalYearNumber Resident Data

Order By FiscalYearNumber;

Re: Previous Value

sunny_talwar — Mon, 17 Aug 2015 10:51:01 GMT

May be this within your set analysis of your expression:

{<FiscalYearNumber = {"$(=Num(AddYears(Max(FiscalYearNumber), -1)))"}>}