Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
BigPaul
Contributor
Contributor

Continuous Time in X axis

Hi, 

I need to create a Line Chart like this:

BigPaul_0-1640795337740.png

with:

  • integer values on Y Axis for each minute
  • time values on X Axis

 

Also, X Axis:

  1. Should not diplay all hh:mm:ss with a very long scroll bar.
    it's good (like the image up here) to show hh:mm "sometimes" on X Axis without a scroll bar;
  2. The hh:mm shown "sometimes" on X Axis should in some way be "rounded" (for example, every hour: 20:00, 21:00... not random numbers like the image up here)
  3. Time over 24h must be shown like 25h, 26h etc.

 

I tried these solutions:

  • convert String Values in Continuous Time OR Interval values for x axis,
    so the Y Axis has values for each minute and point (1) written below is satisfied.
    • convert String Values in Time values for x axis
      satisfies point (2) but does not satisfy point (3)
    • convert String Values in Interval values for x axis
      satisfies point (3) but does not satisfy point (2)

Please, does anyone have suggestions for me?

Labels (1)
1 Reply
chris_djih
Creator III
Creator III

i know how to get a continous axis with custom date fields: adding thte $date tag to the field.
But unfortunately there is no $time tag. You may try the field tag: $timestamp
So in load script format your time to Time and after loading your table you simply write:

 

tag yourfieldname with $timestamp;

 

If this doesn't work, my only solution would be to fake a custom x-Axis. by hiding the axis complete and use custom dimension lines (under Add-ons).

If you found help, mark the correct answer and give some likes to ALL contributors, that tried to help.