Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Case Portal has moved to Qlik Community! Read the FAQs to start exploring Support resources.
cancel
Showing results for 
Search instead for 
Did you mean: 
gireesh1216
Creator II
Creator II

Need Help

Hello Team,

Please help me on below scenario. 

we have raw data like below:

IDNAMEDSTATUS
1216GIREESHD1PASS
1216GIREESHD2 
1216GIREESHD3 
1216GIREESHD4 
1217NARESH FAIL
1217NARESHD5 
1217NARESHD6 
1217NARESHD7 

 

Result: Need STATUS as New Status column if ID and NAME is same.

IDNAMEDSTATUSNew Status
1216GIREESHD1PASSPASS
1216GIREESHD2 PASS
1216GIREESHD3 PASS
1216GIREESHD4 PASS
1217NARESH FAILFAIL
1217NARESHD5 FAIL
1217NARESHD6 FAIL
1217NARESHD7 FAIL
1 Solution

Accepted Solutions
Anil_Babu_Samineni

Don't create Dump

If(ID&NAME=Previous(ID&NAME), peek('New_Status'), STATUS) as New_Status

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)

View solution in original post

1 Reply
Anil_Babu_Samineni

Don't create Dump

If(ID&NAME=Previous(ID&NAME), peek('New_Status'), STATUS) as New_Status

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)

View solution in original post