Skip to main content
Announcements
July 15, NEW Customer Portal: Initial launch will improve how you submit Support Cases. IMPORTANT DETAILS
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))