topic Re: current day in QlikView

current day

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hello everyone!

I am back again with another query. I could not seem to find the right expression for my project.

what I want is to get the data total hours of current or latest DAY in my file.

I have used below expression but is giving me zero "0" value.

attached is the sample.

my objective is to get the data per tester on a daily basis (see attached picture)

tresB — Tue, 18 Sep 2018 09:05:51 GMT

Try:

SUM({<OEE={'*UP*'}, WORKWEEK={$(=Max(WORKWEEK))},DAY={$(=WeekDay(Max(DATE)))} >}HRS)

pooja_prabhu_n — Tue, 18 Sep 2018 10:11:55 GMT

Hi,

DAY is in text format, try Maxstring instead of Max(Day)

SUM({<OEE={'*UP*'}, WORKWEEK={$(=Max(WORKWEEK))}, DAY={$(=MaxString(DAY))} >}HRS)

Thanks,

Pooja

Anonymous — Wed, 19 Sep 2018 01:25:11 GMT

Hi Pooja,

thanks for your help, I did try both your formula and below is my observation.

the second one using maxstring is giving me the previous day data.

while the first one gives the correct data that I need.

thank you so much!

Anonymous — Wed, 19 Sep 2018 01:28:03 GMT

Hi Tresesco,

Your formula perfectly works!

thanks a lot...