topic Re: Axis configuration in QlikView

Axis configuration

slondono — Wed, 25 Nov 2020 16:16:04 GMT

Hi everybody

I have a problem with my chart's axis.

the Y-Axis is time in hours. In the example there is 170 hours.

I attach the qvw. hope you can help me.

Re: Axis configuration

antoniotiman — Fri, 26 Aug 2016 14:50:20 GMT

Hi Sebastian,

try to change 'Number'

Re: Axis configuration

stigchel — Fri, 26 Aug 2016 15:05:41 GMT

For the expression you can use

Time#($(vHoras_tiempo_atencion)&':'&$(vMin_tiempo_atencion)&':'&Num($(vSecs_tiempo_atencion)),'hh:mm:ss')

And on the Number tab set the number format settings to Time

Re: Axis configuration

slondono — Fri, 26 Aug 2016 15:08:53 GMT

I need have marked the 'predefinition expression' because i need the format HHH:MM:SS in the pop up text.

When i do what your doing i lose the HHH:MM:SS format in the pop up.

Re: Axis configuration

slondono — Fri, 26 Aug 2016 15:14:34 GMT

Doesnt work :s

Re: Axis configuration

stigchel — Fri, 26 Aug 2016 15:26:24 GMT

You can maybe use the dual function in the expression, Dual(Text,Number). It will rake the text part for any label presentation and the number for the plotting of the values

Re: Axis configuration

antoniotiman — Fri, 26 Aug 2016 15:42:59 GMT

Use Format Number hh:mm:ss

Re: Axis configuration

Anil_Babu_Samineni — Fri, 26 Aug 2016 16:19:01 GMT

What are you expecting for Pop-Up? from HHH:SS:MM to ?????