topic Time Format in Pivot Chart ExpressionHe in QlikView

Time Format in Pivot Chart ExpressionHe

Tue, 14 Apr 2015 08:10:12 GMT

Hey everyone.

I am creating a Pivot Chart, but one of my expressions is Time (e.g. 01:00, 02:00 etc)

The problem is that it will show as Numeric instead of Time. (see screenshot)

I cannot seem to change this format to Time in the chart, it works perfectly in normal list boxes.

Any help is appreciated

and for a real challenge i refer you to my other post:

The person who can help me with that one deserves bonus points!

Kind Regards.

Mike Cleven

MK_QSL — Tue, 14 Apr 2015 08:16:37 GMT

Try below calculated dimension

Time(Time#([Till Time],'h:mm:ss'))

Tue, 14 Apr 2015 08:20:59 GMT

I tried it, but that didn't work.

However i tweaked it and made it =Time([Till Time],'h:mm:ss') and that works!

Thanks!