topic Re: Qlikview graph and expression in QlikView

Qlikview graph and expression

Tue, 17 Nov 2015 09:00:01 GMT

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.

Re: Qlikview graph and expression

Anonymous — Tue, 17 Nov 2015 11:36:53 GMT

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)

Re: Qlikview graph and expression

Anonymous — Tue, 17 Nov 2015 11:42:12 GMT

see the attachment

Re: Qlikview graph and expression

jyothish8807 — Tue, 17 Nov 2015 11:55:54 GMT

Hi Daniesh,

PFA

Regards

Re: Qlikview graph and expression

Tue, 17 Nov 2015 12:30:02 GMT

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

Re: Qlikview graph and expression

Tue, 17 Nov 2015 12:33:39 GMT

Hi Jyotish,

I am not able to open Total Dur.qvw

Re: Qlikview graph and expression

Anonymous — Tue, 17 Nov 2015 13:17:37 GMT

did you try my solution?

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

Re: Qlikview graph and expression

jyothish8807 — Tue, 17 Nov 2015 13:35:20 GMT

Please try this:

Regards

Re: Qlikview graph and expression

Tue, 17 Nov 2015 14:12:10 GMT

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