Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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$);
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$);
Thx Sunny, worked like a charm