Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
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;

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

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)