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: 
sk0
Contributor
Contributor

tAggregateRow

Hai,

1. I have a input file 

c1,c2,c3,c4,c5

1,x,x,x,x

x,1,x,x,x

x,x,1,x,x

x,x,x,1,x

but i need a output as "1,1,1,1,x"

Thank you.

 

 

Labels (2)
1 Solution

Accepted Solutions
akumar2301
Specialist II
Specialist II

Solution 1)
Tsortrow . Your output would be 1st or last last row

Solution 2) min/max in taggregaterow

View solution in original post

5 Replies
akumar2301
Specialist II
Specialist II

Solution 1)
Tsortrow . Your output would be 1st or last last row

Solution 2) min/max in taggregaterow
sk0
Contributor
Contributor
Author

I Cant able to do it .
could you please explain me clearly.
Thank you.
akumar2301
Specialist II
Specialist II

0683p000009M4ke.jpg

sk0
Contributor
Contributor
Author

Thank you for the help will be in touch 

dilip_n
Contributor II
Contributor II

0695b00000dcgEbAAI.png