Duration format on map

[LenCa]

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

L.

[Nags]

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.

[LenCa]

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.

[LenCa]

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. 

[Nags]

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.

[CNH_1978]

Hi all,

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

[Nags]

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.