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

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
sushantk19
Creator
Creator

how to get a value within same group

Hi,

 

I have the below scenario:

 

Orders_ID   Flag1   flag2

100               Y          N

100               N          Y

100               N          N

100                N         N

 

so basically for same order we have 4 rows, now in target i want to load a single row for order_id with  flag1=Y and flag2=Y ,if one of the records have a Y flag. How can i achieve this result.

Labels (2)
1 Solution

Accepted Solutions
TRF
Champion II
Champion II

tAggregateRow with Orders_ID as "Group by" column and "max" (as Y is greater than N) as Function for both outpout column Flag1 and Flag2.

View solution in original post

2 Replies
TRF
Champion II
Champion II

tAggregateRow with Orders_ID as "Group by" column and "max" (as Y is greater than N) as Function for both outpout column Flag1 and Flag2.
sushantk19
Creator
Creator
Author

@TRF : Thanks! I get the intended result. Thanks for the quick reply.