Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Script is not working properly

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.

10 Replies
Not applicable
Author

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');