Skip to main content
Announcements
Accelerate Your Success: Fuel your data and AI journey with the right services, delivered by our experts. Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
datashaw
Contributor III
Contributor III

Show Distinct ID's in the Dimension

Hi, 

I would like to show distinct Account ID's in the straight table dimention.

 

my dimensions are  Account ID, Country , Date

 

Expression: 1. Sum(Amount)

2. Count(Account ID)

 

i'm expecting the result with the distinct AccountID in the dimension. but i am getting duplicate ID's would you please resolve the issue. 

 

I do not have access to edit the data model or script only access on frontend in qlik sense  

                     

Labels (1)
10 Replies
bala_sundar
Contributor III
Contributor III

Thanks Steve, the Subfield function works and helped me to achieve my objective.