Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
phongnnguyen
Contributor II
Contributor II

aggregation without NULL value in qlik sense

Dear all,

 I have problem with my set analysis. I want to aggregate without NULL value. like my example

 

AccountClientType
A111A111S
T111A111K

 

Each client will has 2 Accounts. and I want to display same a TYPE based on a TYPE of row ACCOUNT=CLIENT. It means , this is what I want:

AccountClientType
A111A111S
T111A111S

 

I'm using set analysis: aggr(nodistinct if(Account=Client,Type),  Client)). But it not works

If you have any solution, please comment for me. Thanks a lot

Cheers,

2 Replies
Channa
Specialist III
Specialist III

can you share ur SET expression

Channa
phongnnguyen
Contributor II
Contributor II
Author

This is my set analysis:

 aggr(nodistinct if(Account=Client,Type),  Client))