Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

clemenceabad
New Contributor III

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 III

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

Life is so rich, and we need to respect to the life !!!
clemenceabad
New Contributor III

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 III

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 !