topic Re: Current Week Selection in QlikView

Current Week Selection

Fri, 20 Nov 2015 07:18:47 GMT

Hi,

Below is my expression for current week data.

If((LeaveStatus='Absent' or LeaveStatus='Present'),

Num(Count(Distinct {<AttendanceWeek = {$(vCurrentWeek)}>} EmpBasicInfoID),'###')

)

But if i select any other week its not showing data. I need to show current week by default and on selection it should show respective weeks data.

Regards,

Keerthi KS

Re: Current Week Selection

PrashantSangle — Fri, 20 Nov 2015 07:20:15 GMT

Hi,

Can you share vCurrentWeek expression????

Regards

Re: Current Week Selection

PrashantSangle — Fri, 20 Nov 2015 07:21:55 GMT

Hi,

If you are using week(today()) then replace it with week(max(datefield))

Regards

Re: Current Week Selection

Fri, 20 Nov 2015 07:22:26 GMT

using week(today())

Re: Current Week Selection

Fri, 20 Nov 2015 07:25:09 GMT

For Month Should i use Month(max(datefield)) ?

Re: Current Week Selection

PrashantSangle — Fri, 20 Nov 2015 07:26:36 GMT

Yes

Re: Current Week Selection

Fri, 20 Nov 2015 07:30:06 GMT

How about for Average time function.

My expression is Interval(Avg(OutTime-InTime),'hh:mm')

It should show current week by default. and on selection it should show for other week

Re: Current Week Selection

PrashantSangle — Fri, 20 Nov 2015 07:36:48 GMT

Hi,

did not get it can you explain little bit more???

Avg(OutTime - InTime) ----- Give you average time between OutTime and InTime.

Regards

Re: Current Week Selection

Fri, 20 Nov 2015 07:39:38 GMT

It gives average time between

If i select week then it will take average of that week.

if i take month it shows average of that month.

By default it should show average of current week.

Re: Current Week Selection

PrashantSangle — Fri, 20 Nov 2015 07:42:16 GMT

Hi,

set analysis inside AVG()

avg({<week={"=$(=week(max(datefield)))"}>} OutTime-InTime)

Regards