Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
You will find the necessary calculations in the attached Qlikview file.
I hope this helps.
Kind regards,
Nuno
PFA
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