Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Multibox Value

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.

Query.JPG

Category.JPG

Regards,

Masba

15 Replies
Not applicable
Author

Please find my attchment..

rajeshvaswani77
Specialist III
Specialist III

Hi,

Have made changes, please check the attached example.

thanks,

Rajesh Vaswani

Not applicable
Author

Dear Rajesh,

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

Qlikview.JPG

Regards,

Masba

rajeshvaswani77
Specialist III
Specialist III

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

Not applicable
Author

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
Specialist III
Specialist III

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