topic Dual IF statment with Previous in QlikView

Dual IF statment with Previous

Tue, 28 Feb 2017 14:47:34 GMT

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

Re: Dual IF statment with Previous

sunny_talwar — Tue, 28 Feb 2017 15:01:17 GMT

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$);

Re: Dual IF statment with Previous

Wed, 01 Mar 2017 14:24:44 GMT

Thx Sunny, worked like a charm