topic Re: 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? in App Development

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?

Thu, 03 Dec 2015 19:25:13 GMT

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

Re: 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?

sunny_talwar — Thu, 03 Dec 2015 19:32:39 GMT

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);

Re: 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?

Thu, 03 Dec 2015 20:26:27 GMT

thanks Mr Sunny, It's working.

Re: 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?

sunny_talwar — Thu, 03 Dec 2015 20:53:27 GMT

Great, I am glad it does