topic Re: Format issue in Label in QlikView

Format issue in Label

peterderrington — Tue, 09 Mar 2021 12:57:43 GMT

Hi, I'm having a small formatting issue with a label that i need some help with.

I have line graph which shows the Overall Median Average of the Average time of transfer which uses this expression:

Median(TOTAL AGGR([PAS Time],[PAS Date]))

For the label i want it to show the average time however when i use this expression as the label name it shows the time in decimal: =Concat('Overall Median Average' & ' - ' & Median(TOTAL AGGR([PAS Time],[PAS Date]),))

I tried to alter it to =Concat('Overall Median Average' & ' - ' & Median(TOTAL AGGR([PAS Time],[PAS Date]),'00:00:00')) but that doesn't help, in fact it means it doesn't show any number.

Any ideas?

Re: Format issue in Label

QFabian — Tue, 09 Mar 2021 15:29:40 GMT

Hi @peterderrington , please try this :

='Overall Median Average - ' & time(Median(TOTAL AGGR([PAS Time],[PAS Date])), 'hh:mm:ss')

Re: Format issue in Label

peterderrington — Tue, 09 Mar 2021 16:08:02 GMT

Nope, It stays as a decimal.

If i change the '00:00:00' to 'hh:mm:ss' the number just disappears

=Concat('Overall Median Average' & ' - ' & Median(TOTAL AGGR([PAS Time],[PAS Date]),'hh:mm:ss'))

Re: Format issue in Label

rwunderlich — Tue, 09 Mar 2021 18:51:15 GMT

Why are you using the Concat() function here? I think that's incorrect.

-Rob

Re: Format issue in Label

peterderrington — Tue, 09 Mar 2021 19:05:36 GMT

That’s the way I’ve always set the expression in a label when I want it to return the value of the main expression after (or before) in the label of the legend. Happy to do it another way if there’s a better way though.

Re: Format issue in Label

rwunderlich — Tue, 09 Mar 2021 20:02:27 GMT

I don't think you want to use Concat here. Did you try @QFabian suggestion as he wrote it? I think that is correct.

-Rob

Re: Format issue in Label

QFabian — Tue, 09 Mar 2021 21:26:34 GMT

Hi again @peterderrington , please send us a little data set to test, because probably the problem is in the source data time format.

Please teel me what is the value you get using this : Median(TOTAL AGGR([PAS Time],[PAS Date])

Re: Format issue in Label

peterderrington — Wed, 10 Mar 2021 09:38:36 GMT

Obscurely today its working lol - amazing what a reboot will do.

Its created a new problem whereby this overall average isn't showing when you select a sub set of months but i'll look into this separately.

Thank you for all your help