topic Extract data from data by conditionally in QlikView

Extract data from data by conditionally

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

Hi All,

Please have a look at attachment for details.

Thanks,

Nihhal.

ahaahaaha — Tue, 04 Jul 2017 08:30:43 GMT

Hi Nihhal,

May be as at attached file.

Regards,

Andrey

vinieme12 — Tue, 04 Jul 2017 08:37:29 GMT

do you already have a flag that specifies start and end date?then just use

Max({<Dateflag={'StartDate'}) Date) for StartDate

and Max({<Dateflag={'EndDate'}) Date) for EndDate

nihhalmca — Tue, 04 Jul 2017 12:08:55 GMT

Hi Andrey,

Thanks for your attachment.

Actually i have to give logic while extracting data from table (edit script) instead of UI.

I need to extract only required records from data source (latest startdate and enddate per each patid) instead of all records.

maxgro — Tue, 04 Jul 2017 12:26:35 GMT

LOAD PatID, Code, Date

FROM [Source.xlsx] (ooxml, embedded labels, table is DB);

S1:

NoConcatenate

load PatID, Code, Date as EndDate

Resident S

Where PatID <> Peek('PatID')

order by PatID, Code desc;

left join (S1)

load PatID, Code +3 as Code, Date as StartDate

Resident S;

DROP Table S;