Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Not applicable

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?

AgentNameHoursNumer_of_Calls_OnAgent
varun12AM33
varun1AM28
varun2AM26
varun3AM18
varun4AM15
varun5AM10
varun6AM25
varun7AM57
varun8AM86
varun9AM206
varun10AM310
varun11AM318

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

3 Replies
MVP
MVP

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?

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


Capture.PNG

Not applicable

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?

thanks Mr Sunny, It's working.

MVP
MVP

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?

Great, I am glad it does