Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

clemenceabad
New Contributor II

cut an axis graph by half hour

Hi everybody !


I want to modify my abssices axis by half an hour like e.g. 7am to 7:30 am, 7.30am to 8 am etc ...


I tried =class(date(HourField,hh:mm),0.5) it's not the right solution.


Someone help me ?

Thanks !

Clémence

Tags (1)
1 Solution

Accepted Solutions
clemenceabad
New Contributor II

Re: cut an axis graph by half hour

I solved my problem with this syntax :

=date(class(date(HeureAbsolue,'hh:mm'),'00:30'),'hh:mm') and the result is : (on an other example)

thank you for looking to help me !

3 Replies

Re: cut an axis graph by half hour

You want field or Front End? Can you share sample

clemenceabad
New Contributor II

Re: cut an axis graph by half hour

This is it :

I want to transform "7" to "7<x<7:30" and "7:30 to 8" for example

Thanks for help

clemenceabad
New Contributor II

Re: cut an axis graph by half hour

I solved my problem with this syntax :

=date(class(date(HeureAbsolue,'hh:mm'),'00:30'),'hh:mm') and the result is : (on an other example)

thank you for looking to help me !