# New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Contributor

## Percentage calculation help

Hi Experts,

Can any one please help me to calculate the below percentage column in qlik how to write expression of 192

1 Solution

Accepted Solutions
Esteemed Contributor

## Re: Percentage calculation help

Hi,

Percentage:

=Count(distinct id)/Count(distinct total id)

on the number tab, on the expression check "show in percentage %"

4 Replies
Esteemed Contributor

## Re: Percentage calculation help

Hi,

Percentage:

=Count(distinct id)/Count(distinct total id)

on the number tab, on the expression check "show in percentage %"

MVP

## Re: Percentage calculation help

try with total

count(DISTINCT id) / count(TOTAL DISTINCT id)

What does the TOTAL qualifier do?

Esteemed Contributor

## Re: Percentage calculation help

If u don't, and select a product, u'll have as % 100%.

=Count(distinct id)/Count(distinct {<Product>} total id)

Contributor

## Re: Percentage calculation help

Yes Omar you are right with out {<Product>} getting 100% while selecting any specific product.