topic class function and clock in QlikView

class function and clock

Mon, 11 Oct 2010 15:19:57 GMT

Hi everyone,

I'm trying to do this :

=class(HRE_SORTIE, timestamp('0.0833','hh:mm'), 'Heures')

thing is, in the graphic chart , it's shown like that : 0.08333<Heures<0.0.....

The HRE_SORTIE field store clock data like this : 14:00,12:55......(thanks to timestamp) and even if I put class(HRE_SORTIE, '2:00' , 'Heures') as a dimension in the chart, it's still shown like this : 0.08333333<Heures<0.0..... in the graphic chart.

How can I do to display '0:00<Heures<2:00' in this chart?

Thx ,

Will

class function and clock

Mon, 11 Oct 2010 15:36:13 GMT

Hi Will, you can use a calculated dimmension similiar to the following:

=time(subfield(class(TH, '2:00' , 'Heures'),'<=',1),'HH:MM:SS') & ' <= Heures < '& time(subfield(class(TH, '2:00' , 'Heures'),'<',3),'HH:MM:SS')

See attached example.

Regards

Re:class function and clock

Wed, 13 Oct 2010 08:44:59 GMT

Hi,

Your trick finally work. thanks.