How to do condition load on based previous load..

[#1]

Hi,

I'm loving Qlikview but I'm still new to Qlikview development, looking for help from Guru's.

I have 2 tables..1st one with stock.. and second one with details for stock movements(receipts and issues). I 'm interested in stock latest stock movements equal to the stock.

ex: table1 with 2 fields - part_no, stock has 1 records

smt101-102 , 1000

tables 2 has all movements related to this fields, part , date, qty

rec1 - smt101-102, 11/1/2010 , 250

rec2 - smt101-102, 11/15/2010, 700

rec3 - smt101-102, 11/25/2010, 200

rec4 -smt101-102, 11/27/2010, 200

In this scenario, I want to load table2 with records - 4, 3, 2 only.

Appreciate your ideas on this.

Thanks

Laks

[marcel_olmo · Accepted solution]

Hi Yelugoti, good to hear that! Qlikview is great!!

Maybe what you really need is to use RESIDENT tables. Have you heard about that?

If I understand well, what you need is :

1- Load the first table.

2- Load the second table with a right join of the "resident table" of the first table (using where clauses to exclude row1).

Hope you understand what I'm trying to say.

Cheers!!

[#3]

Hi Marcel,

Thanks for your reply, I finally got a chance to try as you suggested and glad that I got it working the way I wanted.

Resident load is useful for sorting but unfortunately I had spent so much time thinking that sort didn't work. It made me think that data didn't get sorted as per the script when data appears in table box / stright table, but actually RESIDENT- SORT worked when I checked in data preview.

Any clues why stright table got its own sorting even though I disable everything SORT properties adn set load order to 'original.

Thanks,

Laks

[tresesco]

Hi yelugoti,

When you sort the data using RESIDENT, its original load order is still same. If you want to see the change, STORE the sorted table into QVD and then load it again from QVD. Now you would be able to see the change in sort order by using "Original Load Order".

regards, tresesco