Need help with an expression

[Anonymous]

Hi , once again i need your help     

I have a table that looks like this:

Itemnr     Transdate     Quantity

1              20140218           6

1              20140226           3

1              20140310           0

1              20140329           6

2              20140210           25

2              20140215           19

2              20140316           15

2              20140318           12

I also have a input box where I fill in a date like "20140317"

I want to make a chart object in the form of a straight table with itemnr as dimension.
How can I write an expression that gives me the answer:

Itemnr     Transdate     Quantity

1              20140310           0

2              20140316           15

for each itemnr the quantity of the Transdate that is the next smaller or equal to the input box is returned.

Thanks/ Patric

[#2]

Hi,

You will find the necessary calculations in the attached Qlikview file.

I hope this helps.

Kind regards,

Nuno

[maxgro · Accepted solution]

PFA

[Anonymous]

Thanks alot Nuno and Massimo!!!

You both have a correct solution but with two different solutions.
I will use one of these.
Thank you very much for your help!!!

/Patric