Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
ladislav
Contributor III
Contributor III

Format Pattern interval setup

Hi,
I have an issue with Format Pattern field setup.

My chart shows ticket resolution time in hours (interval).

I want to set up my vertical axis to show hours and indicate that those values shown on axis are in 'Hours' ( like 10h,12h,14h etc. ). But when I write 'h' into Format Pattern field it is recognizes as format of the axis not as integer value 'h'. I can't get trough this.

Can you give me some suggestions please?

Thanks
Capture.PNG

1 Reply
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

Try changing the expression itself so that it formats the data in the expression: =interval(avg(SomeField),'h') & ' h'. Then use Expression Default as Number Format Setting.


talk is cheap, supply exceeds demand