topic Re: Multibox Value in QlikView

Multibox Value

Sun, 14 Dec 2014 05:50:32 GMT

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

Re: Multibox Value

ecolomer — Sun, 14 Dec 2014 07:05:33 GMT

Can you explain more, please or upload and example file?

Re: Multibox Value

rajeshvaswani77 — Sun, 14 Dec 2014 07:09:33 GMT

Are you dealing with very large datasets?

thanks,

Rajesh Vaswani

Re: Multibox Value

Sun, 14 Dec 2014 07:26:57 GMT

Dear Enrique,

My requirement is that based on user selected value from Multibox/ List Box sql script take it as a parameter. When user click "Reload Button" sql script will be run. For your better understanding please find attachment.

Re: Multibox Value

Sun, 14 Dec 2014 07:32:15 GMT

Dear Rajesh,

Not dealing with very large but medium..

Thanks,

Masba

Re: Multibox Value

rajeshvaswani77 — Sun, 14 Dec 2014 08:38:58 GMT

Hi Masba,

Please use this

Connection string here

Customer_Order:

LOAD co,sp,ct,cd;

SQL Select statement here without category desc in the where condition instead add CT.MAIN_CATEGORY_DESC cd in the LOAD as well as the select statement.

in listbox add ct so that you can select.

thanks,

Rajesh Vaswani

Re: Multibox Value

Sun, 14 Dec 2014 08:50:14 GMT

Dear Rajesh,

Thanks for your reply. Can u give one example with Code that will be helpful for me as a new qlikview developer.

Regards

Masba

Re: Multibox Value

rajeshvaswani77 — Sun, 14 Dec 2014 08:58:32 GMT

Have you made the connection string?

Re: Multibox Value

rajeshvaswani77 — Sun, 14 Dec 2014 09:09:05 GMT

please go through this link.

http://community.qlik.com/docs/DOC-1986

Will be helpful.

thanks,

Rajesh Vaswani

Re: Multibox Value

Sun, 14 Dec 2014 09:10:32 GMT

Dear Rajesh,

Yes.. I have made my connection string... As per your insturction i have updated my qlikview file. please see my attchment and please help me ..

Regards,

Masba

Re: Multibox Value

Sun, 14 Dec 2014 09:13:32 GMT

Please find my attchment..

Re: Multibox Value

rajeshvaswani77 — Sun, 14 Dec 2014 09:25:22 GMT

Hi,

Have made changes, please check the attached example.

thanks,

Rajesh Vaswani

Re: Multibox Value

Sun, 14 Dec 2014 09:57:20 GMT

Dear Rajesh,

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

Regards,

Masba

Re: Multibox Value

rajeshvaswani77 — Sun, 14 Dec 2014 09:59:51 GMT

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

Re: Multibox Value

Sun, 14 Dec 2014 10:25:32 GMT

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.. )

Re: Multibox Value

rajeshvaswani77 — Sun, 14 Dec 2014 10:31:51 GMT

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