topic for each in unique file in QlikView

for each in unique file

Tue, 19 Nov 2013 21:48:02 GMT

Hi everyone !

i'm making an script that has a "for each " to stay more fast, because the script has a function call hierarchy, the "for each" is for any customer , the problem is when I do store of file, I record only the data of the first customer.

follow below the part of the script

FOR Each a in 3,2,5

orders:

Hierarchy (order,order_father,level_order,,level_order,,treeview)

LOAD

customer &'-'& order &'-'& product as order ,

customer &'-'&order_father &'-'& product as order_father

customer &'-'& order &'-'& product as order_level ,

Where customer = $(a);

Store orders INTO ..\mylocal\file.qvd

DROP TABLE orders;

//finish

the script above is a little part of the scritp that I use

the problem is that, when I look the qvd, just customer 3 shows, if I to put "For Each a in 5,3,2", the customer that going to show is 5

somebody have some idea ?,

thanks a lot

Re: for each in unique file

Tue, 19 Nov 2013 21:56:37 GMT

Why are using For .. Each loop here ?

You can directly use Match function here like below:

orders:

Hierarchy (order,order_father,level_order,,level_order,,treeview)

LOAD

customer &'-'& order &'-'& product as order ,

customer &'-'&order_father &'-'& product as order_father

customer &'-'& order &'-'& product as order_level ,

Where Match(customer,2,3,5);

Store orders INTO ..\mylocal\file.qvd

DROP TABLE orders;

While using the Hierarchy, the filed names created like Order1, Order2 somthing like

Please check the each inividual load inside for loop and check auto concatenate is working or not ?

Re: for each in unique file

Wed, 20 Nov 2013 00:16:48 GMT

hey !
thank very much, I don't knew of this Match command, thanks a lot, was very fast, my problem was resolved !

answer your question "if loop and check auto concatenate is working or not?"

I put "Concatenate" explict, I think that is workink, but I'll to invistigate the script with loop just for curiosity, and to post the result here