Multibox Value

[#1]

Dear all,

I have a multibox.. User will select value from multibox "Category".. Based on multibox value my script will be execute. Please give me solution.

Regards,

Masba

[#2]

Please find my attchment..

[rajeshvaswani77]

Hi,

Have made changes, please check the attached example.

thanks,

Rajesh Vaswani

[#4]

Dear Rajesh,

Thanks a lot for your reply..when i run your updated file then one error come.. please check attachment

Regards,

Masba

[rajeshvaswani77]

Hi Masba,

Please change the line

Load Category_Code, Category_Desc,co,sp,ct;

to just

Load *;

QlikView scripting is case sensitive

thanks,

Rajesh Vaswani

[#6]

Dear Rajesh,

Thanks for effort and your valuable time.. My requirement was that user will select value from the list and script will be execute only for that value. (Exp:  User select Category Description" Sandal" as a parameter so that  my script will be execute for "Sandal" Category.. )

[rajeshvaswani77]

Dear Masba,

QlikView works in-memory.

Ideally you will write a load script and store that whole table as a Customer_Order.QVD as a file (This will be first QlikView file)

In the second QlikView file you will read whole QVD and then use a list box for applying the Where clause.

The table is fully suppose to be in-memory and you will hit the database only once, and get everything.

You will hit again later after some hours or after a day. This is unlike traditional reporting you would have worked on.

thanks,

Rajesh Vaswani