topic Re: Need TIme in QlikView

Need TIme

ajaykumar1 — Mon, 24 Nov 2014 10:53:55 GMT

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

Re: Need TIme

its_anandrjs — Mon, 24 Nov 2014 12:19:14 GMT

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

Re: Need TIme

ajaykumar1 — Mon, 24 Nov 2014 12:33:38 GMT

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

Thanks,

Ajay

Re: Need TIme

Anonymous — Mon, 24 Nov 2014 13:32:26 GMT

Hi Ajay,

Anand's Solution definately working.

Please see below screen shots:

Regards

Neetha

Re: Need TIme

ajaykumar1 — Mon, 24 Nov 2014 13:48:57 GMT

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?

Re: Need TIme

its_anandrjs — Mon, 24 Nov 2014 13:56:29 GMT

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

Re: Re: Need TIme

thomaswrieck — Mon, 24 Nov 2014 13:59:30 GMT

you may wann try it like shown in attached qvw

Re: Need TIme

its_anandrjs — Mon, 24 Nov 2014 14:05:38 GMT

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.

Regards

Anand

Re: Need TIme

ajaykumar1 — Mon, 24 Nov 2014 14:10:23 GMT

Thanks Anand.Its working.

Can i use these variables in other application?

Ajay

Re: Need TIme

Anonymous — Mon, 24 Nov 2014 14:12:07 GMT

Yes that's correct.