Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

How to count same value only one time?

Hi

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?

551

552

553

551

as only 3 posts?

/Thanks!

1 Solution

Accepted Solutions

How to count same value only one time?

Hi,

     Use Count(Distinct DecisionID).

     Distinct keyword selects only unique data.

Celambarasan

2 Replies

How to count same value only one time?

Hi,

     Use Count(Distinct DecisionID).

     Distinct keyword selects only unique data.

Celambarasan

MVP & Luminary
MVP & Luminary

How to count same value only one time?

Hi,

Try using the Distinct option in Count()

=Count(Distinct DecisionID)

Regards,

Jagan.