topic Re: box plot and formatting values in QlikView

box plot and formatting values

ali_hijazi — Wed, 01 Apr 2015 09:01:36 GMT

Hello

got a box plot chart

the expression is sum(duration)

where duration is a number in minutes

what I want is display in the pop up the min and max values in the form of hh:mm

I tried to update the expression and put num(floor(sum(duration)/60),'00') & ':' & num(mod(sum(duration),60),'00') but this will cause the chart not to be drawn

please advise

Re: box plot and formatting values

rubenmarin — Wed, 01 Apr 2015 09:13:17 GMT

Hi Ali, your expression returns a string, wich can't be located in a plot char, try with this expression:

Interval(Sum(Duration)/1440, 'hh:mm')

This will return a number in the format hh:mm.

Re: box plot and formatting values

MK_QSL — Wed, 01 Apr 2015 09:13:26 GMT

=Interval(Time#(SUM(duration),'mm'),'hh:mm')

Re: box plot and formatting values

ali_hijazi — Wed, 01 Apr 2015 09:32:44 GMT

the same this will return string

Re: box plot and formatting values

ali_hijazi — Wed, 01 Apr 2015 09:40:02 GMT

this will return a string and the chart will fail to be drawn

Re: box plot and formatting values

rubenmarin — Wed, 01 Apr 2015 09:42:54 GMT

Hi Ali, this is a number with a string representation, QV will now where to locate it, you tried the expression?

Re: box plot and formatting values

ali_hijazi — Wed, 01 Apr 2015 10:17:47 GMT

this is where QV is locating your suggested expression

it should be at the X symbol

Re: box plot and formatting values

rubenmarin — Wed, 01 Apr 2015 10:35:27 GMT

And where is expected to be located? if Y-axis should be the minutes you only need Sum(Suration)...for the text reprentation in pop-up when it's different than the value you can use dual function, ie:

Dual(Interval(Sum(Duration)/1440, 'hh:mm'), Sum(Duration))

Re: box plot and formatting values

ali_hijazi — Wed, 01 Apr 2015 10:46:19 GMT

what i want is the following

instead of seeing 226 mins; I want to see 3:46