Discussion board where members can get started with QlikView.
I have a table with decision and subdecision. Each subdecision are connected to the main decision by a decisionID. I want to count the decisionID but only ones. So, what function do I use to only count uniq IDs?
as only 3 posts?
Go to Solution.
Use Count(Distinct DecisionID).
Distinct keyword selects only unique data.
Try using the Distinct option in Count()