topic Re: Script is not working properly in QlikView

Script is not working properly

Wed, 14 Dec 2011 12:16:32 GMT

Hello,

Here i'm attaching one zip file it consits of one qvw file and one qvd file.

Ok coming to my task. I developed my application with more than than 300 fields. Now for each field i want to catch min an max values and also i'm creating dummy fields for this result. After that i'm making input fields for min and max fields.

I developed script in two ways:

1) Quick load for min and max

2) Slow load for min and max

In the first script i'm not able to get accurate values for min and max. In the second script i'm able to get accurate values for dummy fields.

Can any one help me how to solve this problem.

For more information go through the enclosed qvw file.

Script is not working properly

Thu, 15 Dec 2011 09:35:26 GMT

Qlikvie guru's please help me on this. I think what i explained in previous post is clear if not ask me..

Re: Script is not working properly

Miguel_Angel_Baeyens — Fri, 16 Dec 2011 10:42:26 GMT

Jacq,

The script loads fine at a first glance. Which values should be correct so we can check whether the reload is taking the correct values from the QVD file?

Regards,

Miguel

EDIT: The part marked as "slow" is concatenating tables, so that's unlikely you get proper values where TakeOver, MaxTakeOver and so are shared between two tables.

Script is not working properly

Fri, 16 Dec 2011 14:17:55 GMT

Miguel

The zip file which i've given you have loaded with only 3 fields(i.e.,BCButtterflyTimeA,BCRobotTimeA,BCRobotVacA). The Min and Max values are displayed in the text box but the values are different in the generated fields i.e MinTakeOver, MaxTakeOver,MinTakeOver1, MaxTakeOver1.

Re: Script is not working properly

llauses243 — Mon, 19 Dec 2011 00:38:03 GMT

Hi jacq,

This is my offer, pls to see image attached

Good luck, Luis

Re: Script is not working properly

rwunderlich — Mon, 19 Dec 2011 02:46:38 GMT

Jacq,

You are trying to get the min/max values by using the load fieldvalues() technique for speed. Good idea, but there are a some problems in your script.

1. The test

While Len(FieldValue('BCRobotTimeA', IterNo())) > 0

won't work because you do indeed have a zero length values in your data. I think Luis already pointed this out. I think a better way to control the loop is:

AutoGenerate(FieldValueCount('BCRobotVacA'))

2. When you load the fieldvalue, you name the new field same as the field you are loading. While I can't say for sure that is a problem, it seems illogical and potentially problematic.

3. The INPUTFIELD statement should be specified only once in your script.

Try the script below repeated for each field. I'm using preceding load so there is no need to create and drop a temp table.

Max_TakeOver:

LOAD *, MinTakeOver as MinTakeOver1, MaxTakeOver as MaxTakeOver1;

LOAD 'BCButtterflyTimeA' as TakeOver,

max(X) as MaxTakeOver,

min(X) as MinTakeOver

;

LOAD FieldValue('BCButtterflyTimeA', recno()) as X

AutoGenerate(FieldValueCount('BCButtterflyTimeA'))

;

-Rob

http://robwunderlich.com

Script is not working properly

Mon, 19 Dec 2011 05:43:42 GMT

Thanx Luis and Rob.. I'll check and get back to you once i reach my office.

Re: Script is not working properly

Mon, 19 Dec 2011 11:39:40 GMT

ya i'm getting accurate values..But when i use updated qvd file. The input fields are holding the previous qvd file data only. The input fields are not reset to initial value.

For your reference i'm attaching one zip file with two qvd files. Load the application by changing the names of qvd file in editscript and see the result.

Re: Script is not working properly

rwunderlich — Mon, 19 Dec 2011 17:15:55 GMT

What you are seeing is expected behavior. Input Field values survive reload by design. The only way I know to automatically reset them is with a macro as discussed in other threads. Perhaps someone else has an idea as to how they can be reset in script.

-Rob

Re: Script is not working properly

Mon, 19 Dec 2011 18:00:40 GMT

Rob Wunderlich

Yes you are right.. I have gone through few threads in community. This thread has given me the details about input field functionality. But i'm not able to find the solution for my problem. If possible can you please check.

Re: Script is not working properly

Mon, 30 Jan 2012 12:20:09 GMT

Hello All,

I need help from you. I want to link below tables. How it is posible? Please help me

//****************** Current Data **************

Sample:

LOAD BCButtterflyTimeA,

BCRobotTimeA,

BCRobotVacA,LotNo,LensKey

FROM

D:\LGUI\2_QvdGenerator\QVD\RTQMain.qvd

(qvd);

//********** TakeOver ****************************************************************************************

SUB MinMax(Str)

All_$(Str):

LOAD FieldValue('$(Str)', IterNo()) as $(Str)

AutoGenerate(1)

While not IsNull (FieldValue('$(Str)', IterNo()));

INPUTFIELD MinTakeOver,MaxTakeOver;

Max_TakeOver:

LOAD TakeOver,MinTakeOver, MaxTakeOver, MinTakeOver as MinTakeOver1, MaxTakeOver as MaxTakeOver1;

LOAD '$(Str)' as TakeOver,

max($(Str)) as MaxTakeOver,

min($(Str)) as MinTakeOver

Resident All_$(Str);

DROP Table All_$(Str);

ENDSUB

CALL MinMax('BCButtterflyTimeA');

CALL MinMax('BCRobotTimeA');

CALL MinMax('BCRobotVacA');