Dual IF statment with Previous

[#1]

Hi

I have a problem that I cant manage to solve maybe you guys could help me out.

The thing i i have 5 recall ids that have diffrent status, I want to mark the recall id that has the status deleted. IF a recall ID is deleted it should show on all the rows

in the example case recall ID 3 is deleted so I want t filter out that id so it does not show at all event the status created and used should not show for that recall id.

I tried to order by stats and check for the deleted status but it does not work. Any ideas? Se the attached example

if(Recall_ID=Previous(Recall_ID) AND Previous(Status='Deleted'),'Deleted','Active') as Deleted

thx

[sunny_talwar · Accepted solution]

May be using Mapping Load:

MappingTable:

Mapping

LOAD DISTINCT Recall_ID,

    Status

FROM

[..\..\Downloads\QlikviewExample.xls]

(biff, embedded labels, table is Sheet1$)

Where Status = 'Deleted';

Table:

LOAD Recall_ID,

    DateCreated,

    DateDue,

    Description,

    Status,

    ApplyMap('MappingTable', Recall_ID, Status) as NewStatus

FROM

[..\..\Downloads\QlikviewExample.xls]

(biff, embedded labels, table is Sheet1$);

[#3]

Thx Sunny, worked like a charm