Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
peterderrington
Creator II
Creator II

Format issue in Label

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?

 

1 Solution

Accepted Solutions
QFabian
Specialist III
Specialist III

Hi @peterderrington , please try this :

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

QFabian

View solution in original post

7 Replies
QFabian
Specialist III
Specialist III

Hi @peterderrington , please try this :

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

QFabian
peterderrington
Creator II
Creator II
Author

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'))

 

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

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

-Rob

peterderrington
Creator II
Creator II
Author

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.
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

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

QFabian
Specialist III
Specialist III

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])

QFabian
peterderrington
Creator II
Creator II
Author

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