Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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;

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
sunny_talwar

We think a like

Anil_Babu_Samineni

But, Late as always

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful