Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

aj0031724
Contributor

DD/HH:MM x axes with steps of 2 HOURS LINE CHART

DEAR TEAM ,

SEE ATTACHED.

WE HAVE X AXES IN FORMAT OF (DD/HH:MM) SHOWING 24 HOURS IN A DAY .

AND AS PER CUSTOMER REQUIREMENT THEY NEED TO SEE X AXIS WITH STEP OF 2 HOURS ONLY .

I:E IF DATE IS  30/11/2017 THEN  BEGIN FROM 30/00:00 THEN 30/02:00 ..30/04:00.......30/20:00 ...30/22:00....01/00:00

CAN U PLEASE ADVISE HOW CAN WE HANDLE HOPPING OF 2 HOURS IN X ZES WITH FORMAT OF DD/HH:MM  ADDED AS DIMENSION FOR X XSIS.

WHENVER WE DO CONTINIOUS IN PRESENTATION CHART GIVES"" NO NUMERIC VALUES ON CHARTS""

PLEASE HELP TO ACHIVE 2 HOURS STEP IN XZES WITH DATETIMEFORMAT OF DD/HH:MM.

4 Replies
zhadrakas
Valued Contributor

Re: DD/HH:MM x axes with steps of 2 HOURS LINE CHART

maybe like this

time(round(frac(YOUR_FIELD), 1/12) , 'DD/hh:mm') as Min120Interval

aj0031724
Contributor

Re: DD/HH:MM x axes with steps of 2 HOURS LINE CHART

Dear Tim,

This is what we tried ad per your suggestion in load script :

LOAD DISTINCT  date(DATE,'MM.DD.YY) AS DATE

time(round(frac(DATE), 1/12) , 'DD/hh:mm') AS DateHOUR.

this DATEHOUR IS USED AS DOMENSION .

Howver in GUI LINE CHART IT IS NOW GIVING ONLY 30/00:00 as values

CAN YOU PLEASE ADVISE

zhadrakas
Valued Contributor

Re: DD/HH:MM x axes with steps of 2 HOURS LINE CHART

you have to use this function on a time field.

time(round(frac(YOUR_TIME_FIELD), 1/12) , 'DD/hh:mm') AS DateHOUR

MVP
MVP

Re: DD/HH:MM x axes with steps of 2 HOURS LINE CHART

Try like:

Date(Round(YOUR_FIELD, 1/12) , 'DD/hh:mm') as Every2Hrs

Community Browser