Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am trying to extract zoho data in qlikview.
here i am trying to extract those users working hours who worked on weekend
so in zoho total hours is this for 3-nov-2018 date
i am trying to calculate same in qlikview
i do this
SUM(If(Week_Day = 'Sat' or Week_Day = 'Sun',timestamp(WorkingHours)))
but this shows me these hours
I have this data
TotalHours | To_Date | ToTime | WorkingHours | BreakTime | InputType | From_Date | FromTime |
7:30 | 11/3/2018 | 16:31:02 | 7:30 | 0:00 | 7 | 11/3/2018 | 9:00:24 |
7:30 | 11/3/2018 | 16:31:02 | 7:30 | 0:00 | 7 | 11/3/2018 | 9:00:24 |
Hi!
Your sum equals 15 because you have two identical rows with 7.5 workingHours. Thus,
SUM(If(Week_Day = 'Sat' or Week_Day = 'Sun',timestamp(WorkingHours))) = 7.5 + 7.5 = 15
You should clean your data during the reload (try with "LOAD Distinct ...")
Regards,
Jaime.
Did Jaime's post help you resolve your issue? If so, be sure to return to the thread and use the Accept as Solution button on their post to give them credit for the help and to let the other Community Members know that was the issue. If you figured something else out, please consider posting the issue and then mark that as the solution....
Regards,
Brett