topic Re: Chart Dimension Offset in QlikView

Chart Dimension Offset

Thu, 30 Apr 2015 08:10:42 GMT

Hey All.

I am creating a Bar Chart based on hours in a day.

I have the data hourly, but the problem is that our business day's start at 4 am (no this cannot be changed)

And the chart will automatically sort from 01:00:00 to 02:00:00 and so on.

We would like to see the chart start at 04:00:00 move from there.
How can i achieve this offset?

If i go to the sort tab in the properties i cannot seem to fix this.

Re: Chart Dimension Offset

robert_mika — Thu, 30 Apr 2015 08:38:21 GMT

You can either use Wildmatch in the sort by Expression options:

WildMatch(Time,04:00:00,05:00:00...)

or use Dual in the load sscript

Data:

mapping load * Inline

[ Time,Value

04:00:00,1

05:00:00,2 ]...

ans so on...

Sort:

load

Employe,

dual(Time,ApplyMap('Data',Time)) as Rate

FROM

Re: Chart Dimension Offset

Gysbert_Wassenaar — Thu, 30 Apr 2015 08:43:24 GMT

Try sorting by an expression. Something like mod(only({1}Time)*24-4,24). See attached example.

Re: Chart Dimension Offset

Thu, 30 Apr 2015 08:49:57 GMT

Hi mike

Please try with mod(only({1}Time)*24-4,24) it should work.

thanks

Re: Chart Dimension Offset

Thu, 30 Apr 2015 08:53:19 GMT

Unfortunately mod(only({1}Time)*24-4,24) wont work, it errors on 'Time' (red underline)

Wildmatch wont work either.
I guess i can try the script.

Was hoping that wasn't needed.

Re: Chart Dimension Offset

Gysbert_Wassenaar — Thu, 30 Apr 2015 08:54:35 GMT

Replace Time with the name of the dimension that contains your hour values.

Re: Chart Dimension Offset

Thu, 30 Apr 2015 08:58:47 GMT

Lol, i should have known that.

however, the sorting gets messed up if i do this, see picture.

Re: Chart Dimension Offset

robert_mika — Thu, 30 Apr 2015 09:33:47 GMT

Could you post your file?

Are you sorting by both of your expression?

Re: Chart Dimension Offset

Thu, 30 Apr 2015 13:51:46 GMT

Unfortunately i cannot considering it is based on a different server without direct access.

i will try everyone's suggestions again after my reload.

Thanks in advance!