topic Re: Need help with an expression in QlikView

Need help with an expression

Anonymous — Tue, 17 Feb 2015 21:33:40 GMT

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

Tue, 17 Feb 2015 22:51:12 GMT

Hi,

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

I hope this helps.

Kind regards,

Nuno

maxgro — Tue, 17 Feb 2015 22:51:28 GMT

PFA

Anonymous — Wed, 18 Feb 2015 10:42:37 GMT

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