Qlikview graph and expression

[#1]

Hi,

I have a requirement where i have show on dashboard the employees completing 8 hours and employees not completing.

I raised the issue with Qlikview but due to time format of IN_TIME and OUT_TIME was not able to display. Now we have added one column TOT_DUR which counts the duration.

Now the requirement is that i want to display the count of TOT_DUR less than or equal to and greater than or equal to in a graph and who has completed 8 Hours maximum time .

I am very new to qlikview.

Please help me which graph will be best suited and expression which will display which users has max tot_dur 8 and count details.

I have attached the data is excel.

Please help.

[Anonymous]

say if you are having a dimension like EmployeeName then,

In dimension tab, add the dimension EmployeeName and edit it with following:

=if(aggr(sum(Tot_Duration), EmployeeName)>'08:00', EmployeeName)

Expression: sum(Tot_Duration)

[Anonymous]

see the attachment

[jyothish8807]

Hi Daniesh,

PFA

Regards

KC

[#5]

Hi

we have column name as name

so my expression was

=if(aggr(sum(Tot_DUR), NAME)>'08:00', NAME)

Output is wrong. I would have got 35 but i am getting 55.01.

Employee tot_dur more or equal to 8 is 35 time. but it is showing 55.01

I have attached the time details and emp details.

Thanks

[#6]

Hi Jyotish,

I am not able to open Total Dur.qvw

[Anonymous]

did you try my solution?

dont forget to change the Number Format in Time under Number Tab

[jyothish8807]

Please try this:

Regards

KC

[#9]

Hi balraj,

I am getting below issue after trying your recommendation.

we have column name as name

so my expression was

=if(aggr(sum(Tot_DUR), NAME)>'08:00', NAME)

Output is wrong. I would have got 35 but i am getting 55.01.

Employee tot_dur more or equal to 8 is 35 time. but it is showing 55.01

I have already attached the time details and emp details.

Thanks