Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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');