topic Re: Change expression format in QlikView

Change expression format

techvarun — Wed, 25 Sep 2013 12:10:41 GMT

How to change the display format from date to time

Regards

Re: Change expression format

swuehl — Wed, 25 Sep 2013 12:26:33 GMT

Have you tried changing the number format on Number tab in chart properties to interval?

Re: Change expression format

Wed, 25 Sep 2013 12:27:11 GMT

Within the object properties, simply go to the 'Number' tab and select time as below;

Let me know if that answers your question.

Regards

Steve

Re: Change expression format

techvarun — Wed, 25 Sep 2013 12:39:32 GMT

Hi Steve & swuehl

am getting right values on bar but i need to show the time values on the place which i have rounded on the attached image

Regards

Re: Change expression format

Anonymous — Wed, 25 Sep 2013 14:00:50 GMT

use Dual function something like this dual (expression,num(exp ,'hh:MM:SS')

hope it helps

Sri

Re: Change expression format

PabloOrtiz — Fri, 18 Jul 2014 10:29:27 GMT

Hi,

You have to create a calculate dimension.

Let me see the dataset you used.

Re: Change expression format

Fri, 18 Jul 2014 20:07:00 GMT

Please describe what the chart supposed to show to the user? If it is the average time, then convert your data to a specific unit, like hours or minutes before doing the averaging. Currently it looks like you used the Date format on the "Number" tab of the properties and specified 'h:m:s'.