Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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);
thanks Mr Sunny, It's working.
Great, I am glad it does