Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
apthansh
Creator
Creator

if statement help

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.

4 Replies
sunny_talwar

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

Script or Front end? May be this in script?

Right Join

LOAD ID,

MinString(Status) as Status

Resident Table

Group By ID;

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
sunny_talwar

We think a like

Anil_Babu_Samineni

But, Late as always

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)