topic FirstworkDate is not working when using Resident in QlikView

FirstworkDate is not working when using Resident

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

Hi Friends

I am using FirstworkDate function

My Issue is when I am directly Loading Data from Database and Using Firstworkdate function it's working fine but when I am using

By Resident Firstworkdate is not getting effect

Test:

LOAD Dates,

FirstWorkDate(Dates,8) as [TestDate]

FROM

xyz.qvw

Test2:

LOAD

FirstWorkDate(Dates,8) as [TestDate1]

Resident Test;

TestDate is working fine but TestDate1 is not getting Reflected

My Question is did Firstworkdate function will work when we using Resident??

Could Please help some one this Issue

Please find attached Sample Data and Sample qvw for More clarification

Thank you,

Satya

sunny_talwar — Thu, 11 Aug 2016 09:36:48 GMT

Did you forgot to link your two tables? Try this:

Test:

LOAD Dates,

FirstWorkDate(Dates,8) as [TestDate]

FROM

[Dates_Data.xlsx]

(ooxml, embedded labels, table is Sheet1);

Test2:

LOAD Dates,

FirstWorkDate(Dates,8) as [TestDate1]

Resident Test;

SatyaPaleti — Thu, 11 Aug 2016 10:14:15 GMT

Thank you So Much Sunny. Thats what I Expect

sunny_talwar — Thu, 11 Aug 2016 10:16:31 GMT

Awesome,

Please close this thread by marking the correct response if you are satisfied with it.

Best,

Sunny