Class function

Thu, 17 Nov 2011 10:14:30 GMT

I've a bar chart with dimension 2 and 1 expre.

My first dimension is Carrdatetime the values of this field is in the format of timestamp i.e 10/20/2011 10:30:30.

I want to take only hours for my dimension from this timestamp. So i've written the format of this field as Time(carrdatetime,'hh:mm:ss') in my dimension.

But know i want to display the time with gab of 30 mins.. For this i'm working with Class function i.e =class(Time(carrdatetime,'hh:mm:ss'), 30, 'Hour').

If i take the above as my dimension it is shows the labe data as 40770 <= Hour < 40800 40800 <= Hour < 40830

i want to display time instead of qlikview readed data format. How can i overcome this can any body help me on this.

Re: Class function

lironbaram — Thu, 17 Nov 2011 11:14:39 GMT

hei

try this example

Class function

Thu, 17 Nov 2011 12:24:36 GMT

Liron baram

Thanks a lot for your help me. But can you explain me how it is working. So it helps me in future.

topic Class function in QlikView

Class function

Re: Class function

Class function