Discussion Board for collaboration related to QlikView App Development.
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
May be using Mapping Load:
LOAD DISTINCT Recall_ID,
(biff, embedded labels, table is Sheet1$)
Where Status = 'Deleted';
ApplyMap('MappingTable', Recall_ID, Status) as NewStatus
(biff, embedded labels, table is Sheet1$);
View solution in original post
Thx Sunny, worked like a charm