Discussion board where members can learn more about Qlik Sense App Development and Usage.
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
=count(distinct [Account id])
No luck on (Count distinct AccountID).
I have tried the below calculated dimension but did not get work
Aggr(count( Distinct AccountID) , DATE)
why do you need "Account ID" as dimension?
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