topic Stop auto merging. in QlikView

Stop auto merging.

Tue, 14 Dec 2010 08:50:26 GMT

Hello,

Im trying to create a offerte report but i have a problem with qlikview automergin fields. I have 2 tables 1 with the offer and 1 with offer details.

Offer:

Offer key : 1 Offer number: 2040 : offerdate.

Offer key : 2 Offer number: 2040 : offerdate.

Offer key : 3 Offer number: 2040 : offerdate.

Now when i open the offer number table in qlikview he auto merges the results. Any trick i can use to make him just show 2040 3 times?

Stop auto merging.

Tue, 14 Dec 2010 08:57:44 GMT

Use

Qualify list of fields separated by commas which u don't want to merge.

e.g Quality "Offrer Key","Offer number";

Stop auto merging.

Tue, 14 Dec 2010 09:01:09 GMT

Hey Santosh thank you for your quick reply,

Could u show your solution in a short code sample

cause i don't fully understand what you mean right now.

Regards Luuk

Stop auto merging.

Tue, 14 Dec 2010 10:02:27 GMT

Qualify "Offer Key","Offer Number"; Offer: LOAD * INLINE [ Offer Key,Offer Number,Offer Date 1,2040,1/1/2010 2,2040,1/2/2010 3,2040,1/3/2010 ]; OfferDetails: LOAD * INLINE [ Offer Key,Offer Number 1,2040 2,2040 3,2040 1,2050 2,2050 3,2050 ];