topic Re: Find LogFile latest data in QlikView

Find LogFile latest data

Mon, 29 Feb 2016 10:23:04 GMT

Hi Folks,

i am going to create a dash board with log files, but in the below image it was showing 5 records for Japan.

How to find the latest one, can you help some one..

@Sub2u

Re: Find LogFile latest data

kaushiknsolanki — Mon, 29 Feb 2016 10:31:44 GMT

Hi You can create a new field called time stamp from one of your field like below.

Load *,

Timestamp(Date(Date#(left(Timestamp,8),'YYYYMMDD')) + Time(Time#(Mid(Timestamp,10,6),'hhmmss'))) as New_Stamp

From xyz.

Then as this in your chart and sort on this field.

Regards,

Kaushik Solanki

Re: Find LogFile latest data

Mon, 29 Feb 2016 10:38:09 GMT

Hi Kaushik,

Thanks for the reply.

I applied the above code, but it was not showing any data. In that timestamp "T" is there.

Please help...

@SubbaReddy

Re: Find LogFile latest data

kaushiknsolanki — Mon, 29 Feb 2016 10:41:44 GMT

Hi,

Have a look at the application attached for example.

Regards,

Kaushik Solanki !

Re: Find LogFile latest data

MayilVahanan — Mon, 29 Feb 2016 10:43:18 GMT

May be try like this

First 1 Load * from yourfilename where status = 'FinishedSuccess' Order by Timestamp desc;

Please attach the sample file

Re: Find LogFile latest data

Mon, 29 Feb 2016 11:04:44 GMT

Hi Kaushik,

I am unable to open qvw, can you please send the script..

@SubbaReddy.

Re: Find LogFile latest data

Mon, 29 Feb 2016 11:05:55 GMT

Hi Ramasamy,

I tried, but it was not getting. In timestamp field "T" is there. I hope may be that is the reason...

@SubbaReddy

Re: Find LogFile latest data

kaushiknsolanki — Mon, 29 Feb 2016 11:08:06 GMT

LOad *,Timestamp(Date(Date#(left(Timestamp,8),'YYYYMMDD')) + Time(Time#(Mid(Timestamp,10,6),'hhmmss'))) as New_Stamp

inline [

Timestamp

20160223T090024.495-0800

];

Regards,

Kaushik Solanki

Re: Find LogFile latest data

Mon, 29 Feb 2016 11:12:19 GMT

Hi,

New_Stamp getting blank '-'. I hope its for only one i guess.

when i checked for one it was showing the datetime value.

Thank You..

still in stuck to get the latest record...

@SubbaReddy.

Re: Find LogFile latest data

MayilVahanan — Mon, 29 Feb 2016 11:18:32 GMT

Post your sample data. So that, we can able to find the solution soon

Re: Find LogFile latest data

MayilVahanan — Mon, 29 Feb 2016 11:24:39 GMT

Try like this

LOad *, Timestamp(Timestamp#(Left(Replace(Text(Timestamp), 'T', ''),14),'YYYYMMDDHHmmSS'),'DD/MM/YYYY HH:mm:SS TT') as Time

inline [

Timestamp

20160223T150028.306-0800

];

Re: Find LogFile latest data

Mon, 29 Feb 2016 11:31:45 GMT

Hi,

Please find the below image.

Regards,

SubbaReddy.

Re: Find LogFile latest data

MayilVahanan — Mon, 29 Feb 2016 11:35:06 GMT

Below script also not working?

Load *, Timestamp(Timestamp#(Left(Replace(Text(Timestamp), 'T', ''),14),'YYYYMMDDHHmmSS'),'DD/MM/YYYY HH:mm:SS TT') as Time

inline [

Timestamp

20160223T150028.306-0800

];

Re: Find LogFile latest data

kaushiknsolanki — Mon, 29 Feb 2016 18:53:53 GMT

HI,

It is working fine. whats the issue? What value you are getting and what you want.

Regards,

Kaushik Solanki

Re: Find LogFile latest data

Tue, 01 Mar 2016 01:50:54 GMT

Hi Kaushik,

I want to show only last record of Japan...

@SubbaReddy.

Re: Find LogFile latest data

Tue, 01 Mar 2016 02:59:36 GMT

Subbareddy, first convert the field values into new timestamp field. After that use the group by function on the key filed and Inner join on the Key and maximum time stamp.

Source:

LOAD

Timestamp(Timestamp#(Replace(subfield(text(timestamp_field),'.',1),'T',' '),'YYYYMMDD hhmmss')) as new_timestamp

From source;

InnerJoin(Source)

LOAD

keyfield,

max(new_timestamp) as new_timestamp

resident Source

group by keyfield;