Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
ajaykumar1
Creator III
Creator III

Need TIme


Hi All,


I have one extractor which is used to create the Qvd's and those are used in the applications.


I want to create a separate application to show the below calculations to the user .


This will helpful to developer at which step the application is taking more time to reload.



Need Start time of sales

Sales:

Load * from sales;

Store Sales into D:\Sales.qvd;

Need End time of Sales

Need Start time of Products

Products:

Load * from products;

Store Products into D:\Products.qvd;

Need End time of Products

Need Start time of Mutual

Mutual:

Load Id,Product resident Products;

Drop table Products;

Need End time of Mutual

Drop table sales; (Need Time)

Drop table Products; (Need Time)

I hope you guys understand my requirement.

More Thanks,

Ajay

1 Solution

Accepted Solutions
its_anandrjs

Hi Ajay,

Let assume this simple load

LET vStartSales  = Now();

Sales:

LOAD

Rand() as Sales

AutoGenerate 5200000;

LET vEndSales  = now();

LET vStartProduct = Now();

Products:

LOAD

Rand() as Product

AutoGenerate 5200000;

LET vEndProduct = Now();

LET vStartMutual = Now();

Mutual:

LOAD

Rand() as Mutual

AutoGenerate 5200000;

LET vEndMutual = Now();

And after this you get values in the variables by plot them in the text object.

Deails.png

Regards

Anand

View solution in original post

9 Replies
its_anandrjs

Hi,

Create the variables in the load script

LET vStartSales = Now();

Sales:

Load * from sales;

Store Sales into D:\Sales.qvd;

LET vEndSales = Now();


LET vStartProduct = Now();

Products:

Load * from products;

Store Products into D:\Products.qvd;

LET vEndProduct = Now();

LET vStartMutual = Now();

Mutual:

Load Id,Product resident Products;

Drop table Products;

LET vEndMutual = Now();

LET vSalesDel = Now();

Drop table sales;

LET vProductDel = Now();

Drop table Products;

And take this variables for the information.

Let me know if not works

Regards

Anand

ajaykumar1
Creator III
Creator III
Author

Thanks Anand.But its giving both start time and end time as same.

Thanks,

Ajay

neetha_p
Master
Master

Hi Ajay,

Anand's Solution definately working.

Please see below screen shots:

start.png

End.png

Regards

Neetha

ajaykumar1
Creator III
Creator III
Author

Thanks Neetha.

could you please correct me if am wrong.

let vstarttime =now();

t1:

load * inline [product,amount,place

A,100,iND

B,200,US

C,300,UK

D,400,SWEDEN

E,500,NORWAY];

store t1 into D:\Testing_QV\RES5.QVD;

let vendtime =now();

Note : if am adding this "LET" function to the my script then it will not increase the reload time of application...right?

its_anandrjs

Hi Ajay,

Yes this will not increase the reload time of application and it is small inline table so there is no difference i believe in the start and end time. If there is large data set then you find difference in the start and end.

Regards,

Anand

thomaswrieck
Partner
Partner

you may wann try it like shown in attached qvw

its_anandrjs

Hi Ajay,

Let assume this simple load

LET vStartSales  = Now();

Sales:

LOAD

Rand() as Sales

AutoGenerate 5200000;

LET vEndSales  = now();

LET vStartProduct = Now();

Products:

LOAD

Rand() as Product

AutoGenerate 5200000;

LET vEndProduct = Now();

LET vStartMutual = Now();

Mutual:

LOAD

Rand() as Mutual

AutoGenerate 5200000;

LET vEndMutual = Now();

And after this you get values in the variables by plot them in the text object.

Deails.png

Regards

Anand

View solution in original post

ajaykumar1
Creator III
Creator III
Author

Thanks Anand.Its working.

Can i use these variables in other application?

Ajay

neetha_p
Master
Master

Yes that's correct.