topic Re: Duration format on map in App Development

Duration format on map

LenCa — Mon, 16 Sep 2019 11:03:29 GMT

hi,

we have a point layer map chart. The color of points is based on average time spent on the place of the point. The time used for calculation of the average time is in minutes (e.g. 2500 minutes) and we are getting it from one field in one table. When I want to calculate and show the average time for each point on the map and I hover the mouse, I am getting values in these formats for different points on the map:

0.7

10.3 m

69.4 µ

etc.

I tried to set the format in Custom colors by Measure, using this:

=time(avg([Time]),'hh:mm')

or this

=Interval( Avg( Time), 'dd hh:mm:ss')

but the formats didn't change.

Please, is there any explanation why this is showing time in wrong formats? Do you have any idea what could help here?

Thank you

Re: Duration format on map

Nags — Fri, 07 Feb 2020 03:50:06 GMT

hello Lenca,

Were you able to find the solution for this issue? I have the exact problem. In addition, the legend values in the Area layer / Point layer has the time duration in decimal values. I tried the Interval function, Time function but when I apply it in measures, it always comes back in decimal values.

Example:

Interval(avg(DISPREADY_ALLOCATED_HRS), 'h:mm') --> I used this in Area Layer (or in Point Layer) Colors Measure / expression. I am still getting decimal values not the hh:mm format.

Re: Duration format on map

LenCa — Fri, 07 Feb 2020 06:18:23 GMT

hi Nags,

yes, I was able to solve the issue. It was not the number formatting in load script.

The reason for the wrong format was that the NumericalAbbreviation settings is by default converting very small numbers with many decimals to the format that you are getting. All you need to do is to remove the default converting of very small numbers. Like this:

// SET NumericalAbbreviation='3:k;6:M;9:B;12:T;15:P;18:E;21:Z;24:Y;-3:m;-6:μ;-9:n;-12:p;-15:f;-18:a;-21:z;-24:y';
SET NumericalAbbreviation='3:k;6:M;9:B;12:T;15:P;18:E;21:Z;24:Y;';

This will not convert the decimals.

Re: Duration format on map

LenCa — Fri, 07 Feb 2020 06:33:45 GMT

actually, maybe that doesn't solve your problem completely. I needed the values in money format eventually, so I didn't have the duration problem.

Re: Duration format on map

Nags — Fri, 07 Feb 2020 13:33:09 GMT

As you said, that did not resolve the issue with the duration. I am still getting duration in decimal format, will keep trying to find a solution. Thanks for your reply.

Re: Duration format on map

CNH_1978 — Tue, 11 Feb 2020 11:38:43 GMT

Hi all,

Did anyone find a solution to this, i too have the same problem.

Re: Duration format on map

Nags — Sat, 27 Jun 2020 02:38:00 GMT

I am using Feb 2020 release and it is not fixed yet. Qlik has introduced a tool tip option in April 2020 release. I have to check with the latest release as soon as I get a chance to work on this version.

However, we have opened a ticket to Qlik long back. No response yet.