topic Re: if statement help in QlikView

if statement help

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

Hi , I have my data as below

ID Status Type Amount

1 Active Active 234

1 Complete Active 440

2 Active Active 333

3 Complete Active 220

Here If Status is Active and Complete I want ID with Active to be picked else everything else.I want the output as below.

ID Status Type Amount

1 Active Active 234

2 Active Active 333

3 Complete Active 220

Thanks much.

sunny_talwar — Wed, 14 Feb 2018 13:36:44 GMT

Try this

Table:

LOAD * INLINE [

ID, Status, Type, Amount

1, Active, Active, 234

1, Complete, Active, 440

2, Active, Active, 333

3, Complete, Active, 220

];

Right Join (Table)

LOAD ID,

MinString(Status) as Status

Resident Table

Group By ID;

Anil_Babu_Samineni — Wed, 14 Feb 2018 13:38:01 GMT

Script or Front end? May be this in script?

Right Join

LOAD ID,

MinString(Status) as Status

Resident Table

Group By ID;

sunny_talwar — Wed, 14 Feb 2018 13:43:39 GMT

We think a like

Anil_Babu_Samineni — Wed, 14 Feb 2018 13:46:07 GMT

But, Late as always