Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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 (2)
5 Replies
Highlighted
Creator
Creator

How about:

=count(distinct [Account id])

Highlighted
Contributor III
Contributor III

No luck on (Count distinct AccountID). 

 

I have tried the below calculated dimension but did not get work

Aggr(count( Distinct AccountID) , DATE)

Highlighted
Partner
Partner

why do you need "Account ID" as dimension?

Highlighted
Contributor III
Contributor III

User will export the data into excel, for the analysis purpose they need the each ID level. So must use the ID in dimension, appreciate, is there any other way of doing this 

Highlighted
Creator
Creator

Could you show what you want to achieve?
Because how I understand, either for each [Account ID] there is more than one [Country] or [Date], so it's normal that [Account ID] is duplicating for each unique [Country] or [Date].