topic Re: Line Chart show dimension label every 4 values in QlikView

Line Chart show dimension label every 4 values

richho_microp — Fri, 18 Jul 2014 11:33:23 GMT

I'm sure this must be very simple but I'm going round in circles trying to make this work.

I have a table of values broken down into quarters of a day e.g. 01/07/2014 06:00, 01/07/2014 12:00, 01/07/2014 18:00, 02/07/2014 00:00, etc and I'd like to build a simple line chart that shows the sum of the IN and OUT numbers but only show a single dimension label by day but have four data points between each day.

So currently I have this:

And I'd like something like this (ignore that it shows a label every four days as excel wouldn't let me break down a day into 4 segments)

I've also attached the sample app.

Cheers

Re: Line Chart show dimension label every 4 values

Fri, 18 Jul 2014 12:25:42 GMT

Dear Richard,

This is the best solution i could come up with. You DATE is text field which means you cannot use date functions on. You can change that to the date format using the following syntax in your script:

Date(MakeDate(Left(Right(DATE, Len(DATE)-6), Len(Right(DATE, Len(DATE)-6))-6),

Right(Left(DATE, Len(DATE)-11),len(Left(DATE, Len(DATE)-11))-3),

Left(DATE, Len(DATE)-14)))

Hope this helps.

Regards

Re: Line Chart show dimension label every 4 values

richho_microp — Fri, 18 Jul 2014 13:28:07 GMT

Thank you for your reply and attachment but the business wont accept a bar graph as the current BI tool is able to give them the data in a line chart.

Also I believe a much easier way to get the inline table to show the DATE field as a date data type would be to set the TimeStampFormat to being;

SET TimestampFormat='DD/MM/YYYY hh:mm[.fff]';

That seems to have worked to get the value translated.

Re: Line Chart show dimension label every 4 values

Fri, 18 Jul 2014 14:38:19 GMT

Hi Richard,
Does this give you what you require.

Kind Regards,

Footsie

Re: Line Chart show dimension label every 4 values

richho_microp — Fri, 18 Jul 2014 14:43:41 GMT

I should coco.

Great work, I can see how you've converted the inline data to a date and then used the Continuous Dimension Axis option.

Thank you