topic Re: & in chart expression in QlikView

& in chart expression

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

Hi,

I am trying to add a custom duration expression to my line chart.

Using...

=FLOOR((AVG(IF(TEU=1,UnpackTime)/3600)))&'h'&ROUND(MOD(ROUND(AVG(IF(TEU=1,UnpackTime))),3600)/60)&'min'

...seems to work great in a Text Object however when using this same logic within Line Chart>Properties>Expression>Definition the chart returns blank as per below:

When I remove the &'h' and &'min' the values are displayed on the chart (as per below) but not in the format that I require. Obviously the addition of custom suffixes ('h' and 'mins') is causing the chart to display blank values.

Can someone please tell me how I can get 'h' and 'mins' added to the chart data points so that it is displayed as 3h29mins for example?

Re: & in chart expression

Anil_Babu_Samineni — Fri, 19 Jan 2018 13:24:29 GMT

Perhaps this?

=Dual(FLOOR((AVG(IF(TEU=1,UnpackTime)/3600)))&'h'&ROUND(MOD(ROUND(AVG(IF(TEU=1,UnpackTime))),3600)/60)&'min',FLOOR((AVG(IF(TEU=1,UnpackTime)/3600)))&ROUND(MOD(ROUND(AVG(IF(TEU=1,UnpackTime))),3600)/60))

Re: & in chart expression

Anonymous — Fri, 19 Jan 2018 13:29:05 GMT

Booyakasha!

Thanks a stack it worked a treat!

Re: & in chart expression

Anonymous — Fri, 19 Jan 2018 13:39:15 GMT

What?

booyakasha

(slang) used to express triumph, normally if trying to appear a "gangsta".

Apologies if I offended you lol