Need logic help..

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

Hi,

In attached data i want only those rows in which status is working or if status is resigned then only latest validto date record should be shown.

Please help me out asap..

Regards,

Lalit

Re: Need logic help..

marcus_sommer — Sun, 17 Jul 2016 10:54:23 GMT

Try the following by ensuring that the date-fields will be interpreted as dates which is depending on your default-settings within the variable DateFormat (at the beginning of your script). If not you need to load the fields as dates, like:

date(date#(VALIDTO, 'DD/MM/YYYY')) as VALIDTO

table:

load VALIDFROM, VALIDTO, WORKER, PERSONNELNUMBER, Status

From YourCSV

where match(Status, 'Working', 'Resigned');

inner join (table)

load date(max(VALIDTO)) as VALIDTO, WORKER, PERSONNELNUMBER

resident table

group by WORKER, PERSONNELNUMBER;

- Marcus

topic Re: Need logic help.. in QlikView

Need logic help..

Re: Need logic help..