Hi All,I have one sample dataset like below. I want replace Hours field as 0,1,2 an so on upto 24, Can it will be possible in qliksense?

[#1]

AgentName	Hours	Numer_of_Calls_OnAgent
varun	12AM	33
varun	1AM	28
varun	2AM	26
varun	3AM	18
varun	4AM	15
varun	5AM	10
varun	6AM	25
varun	7AM	57
varun	8AM	86
varun	9AM	206
varun	10AM	310
varun	11AM	318

Hi All,

I have one sample dataset like below. I want replace Hours field such as 12AM ,1AM,2AM .... as 0,1,2 an so on upto 24, Can it will be possible in qliksense?

Thanks,

Bibhuti

[sunny_talwar]

Sure, try this:

Table:

LOAD Time#(Hours, 'hhTT') * 24 as Hours,

  AgentName,

  Numer_of_Calls_OnAgent;

LOAD AgentName,

     Hours,

     Numer_of_Calls_OnAgent

FROM

[https://community.qlik.com/thread/194030]

(html, codepage is 1252, embedded labels, table is @1);

[#3]

thanks Mr Sunny, It's working.

[sunny_talwar]

Great, I am glad it does