How to display the value of a some variable with the help of load statement?

[#1]

Hello Everyone,

I have calculated certain fields for 1 record I got from Database.

The calculation are quite complicated , and I have to create some varibales for that.

I have created 3 variables var1, var2 , var3 for these.

Now I want to store these three variables in a row correspondin to the row..

Then I have to do the same calculation for more rows from the table .

So what I am doing right now is calculating those values and storing the values with the help of

Table1:

SQL select '$(var1)' ,$(var2)' ,$(var3)'  from dual;

Then I am looping the same logic for getting these values for different rows in table.

I am getting the desired result by this process.But the problem is that the query is taking much time.

As it has to unnecessary create database link,execute query over there , and then fetch the result back to QlikView.

Can't we have some dummy table in QlikView which will store the result here itself.

As I just need to store the values row wise corresponding to each record.

When calculation is done for each file , I will just make a .qvd for the table.

Kindly help.

[kaushiknsolanki · Accepted solution]

Hi,

   As i can see you havent use the as keyword. I dont know is this the reason, but pls give a try with that.

   like this.

I_FILE:

    load '$(WO_NBR)'  as WO_NBR,'$(WO_LOT)'  as WO_LOT,'$(L_FIND_DATE)' as CYCLEDATE

    autogenerate $(TOT_RECORD);

Regards,

Kaushik Solanki

[#3]

Thank you for your help!!!

Sorry I missed AS in the load.

Actually I thought it to be optional .

It's working fine now :

  I_FILE:

    load $(I) as Record_number,'$(WO_NBR)' as WO_NBR,'$(WO_LOT)' as WO_LOT,'$(L_FIND_DATE)' as CYCLEDATE

    autogenerate 1;

Can you suggest me any book / material where I can find such basic details .

One more thing can there be any more possible way to minimize the running time of above query.

Actually by incorporating this change the running time has been drastically reduced from 40 mins to 13 mins.

But I have to bring the running time down to 5-8 mins.

One more thing. What I am noticing right now is that QlikView is fetching 360 records at a time from Database.

But as here I have to fetch 50 thousand+ of records, so even simple fetch is also taking a lot of time .

So can we do something about it ?

Thanks in Advance !!!

[kaushiknsolanki]

Hi,

   See it is obvious that more calculation you have the application will take more time to finish it up.

   And as you also know that there are numbers of calculations in your application, so your application will take time.

   I think only way to reduce the time is to use minimum of calculation.

Regards,

Kaushik Solanki

[#5]

Ok.I will try to find some way to reduce the calculation .

Thank you for your kind help !!!!!