Discussion Board for collaboration related to Creating Analytics for QlikView.
Hi can any suggest me how i can find hours from below details
my result would look like
Pls guide why my hour function is not working
thanks in adavance.
Try like this:
hope it helps
You can use hour function but only after formatting your data to the time format using Time#().
Here it still won't work because this is not in correct format 24 hr or 12 hr.
Its total time for more than 1 day. You can use
or simply go by mayil suggestion as
Thanks for reply.i need only 25 so i wll consider this 25 hrs.
Thanks. Sorry i made mistake now i got it correct
thanks to all