topic Re: Get the before column value in QlikView

Get the before column value

wenkew186 — Thu, 17 Mar 2016 09:56:26 GMT

Hi all,

There's a question with get before column value.

I have 2 dates, one is normal SNP date has mapping data. one is special date no data mapping.

I want get the expression1 value use to parameter for expression2. is that possible? how to do it?

see sample file.

sunny_talwar — Thu, 17 Mar 2016 10:00:47 GMT

May be use this expression:

sum({<[SNP Date]={"$(=date(max([Cut off Date]),'YYYY-MM-DD'))"}>} Value)

wenkew186 — Thu, 17 Mar 2016 14:05:45 GMT

thank you Sunny,

I add 2 country for data source, but looks the date not by Country, the expression2 just get the total max date of cut off Date, is there any way?

sunny_talwar — Thu, 17 Mar 2016 14:13:10 GMT

Check this out:

Sum(Aggr(If([SNP Date]= Max(TOTAL <Country> [Cut off Date]), Value), Country, [SNP Date]))

Added another Country in the script:

load * inline [

Country, SNP Date, Cut off Date, Value

USA, 2016-03-01, ,21

USA, 2016-03-02, ,22

USA, 2016-03-03, ,23

USA, 2016-03-04, ,24

USA, ,2016-03-03,

USA, ,2016-03-02,

Canada, 2016-03-01, ,31

Canada, 2016-03-02, ,32

Canada, 2016-03-03, ,33

Canada, 2016-03-04, ,34

Canada, ,2016-03-02,

];

Output:

wenkew186 — Thu, 17 Mar 2016 14:18:14 GMT

se the new sample

sunny_talwar — Thu, 17 Mar 2016 14:19:33 GMT

Kevin Wen wrote:

se the new sample

Not sure what you mean

wenkew186 — Thu, 31 Mar 2016 05:01:42 GMT

It works for me! Great help Sunny, thank you very much!