topic Re: Error in Value in QlikView

Error in Value

Wed, 10 Dec 2014 05:25:46 GMT

Dear all,

I have a multibox and and one input box.. user will select value from the multibox

and data will be automatically filled up into the input box..Based on input box value my script will be execute..But problem is that my script get wrong value from input box.. For your better understanding i have attched my script, error picture...

Script:

Select * From ifsapp.CUSTOMER_ORDER_JOIN_UIV co, ifsapp.SALES_PART sp, ifsapp.CUST_MAIN_CATEGORY ct

where CO.CONTRACT= SP.CONTRACT

and SP.PART_NO= CO.PART_NO

and CO.CONTRACT='D010'

and CT.MAIN_CATEGORY_CODE= SP.MAIN_CATEGORY_CODE

//and CT.MAIN_CATEGORY_DESC like nvl('$(vcat)','%');

and CT.MAIN_CATEGORY_DESC ='$(vcat)';

Regards,

Masba

Re: Error in Value

tresB — Wed, 10 Dec 2014 05:32:05 GMT

Probably while defining your variable vcat in the fron-end, you included ''(single quotes) around it. Try removing them.

Re: Error in Value

jonathandienst — Wed, 10 Dec 2014 06:03:16 GMT

I am fairly certain that the GetFieldSelections function does not work in the script as the fields are not defined until the script run is complete.You will need to assign the GetFieldSelections() values directly to variable vcat before calling the script.

HTH

Jonathan

Re: Error in Value

Wed, 10 Dec 2014 06:17:45 GMT

Dear Jonathan,

Thanks for ur reply. can u give me one example file so that it will be so much helpfull me as a new beginner...

Regards,

Masba

Re: Error in Value

tresB — Wed, 10 Dec 2014 06:26:07 GMT

Check the attached qvw.

Re: Error in Value

SunilChauhan — Wed, 10 Dec 2014 06:45:35 GMT

Load *

Where CT.MAIN_CATEGORY_DESC ='$(vcat)';

Select * From ifsapp.CUSTOMER_ORDER_JOIN_UIV co, ifsapp.SALES_PART sp, ifsapp.CUST_MAIN_CATEGORY ct

where CO.CONTRACT= SP.CONTRACT

and SP.PART_NO= CO.PART_NO

and CO.CONTRACT='D010'

and CT.MAIN_CATEGORY_CODE= SP.MAIN_CATEGORY_CODE

//and CT.MAIN_CATEGORY_DESC like nvl('$(vcat)','%');

Re: Error in Value

Thu, 11 Dec 2014 05:21:52 GMT

Dear Sunil,

Thanks for your response.. Sorry to say u that ur provided solution is not working..

Regards,

masba