Class function

[#1]

Hi

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.

[lironbaram · Accepted solution]

hei

try this example

[#3]

Liron baram

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