Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Thanks Steve, the Subfield function works and helped me to achieve my objective.