Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

mahitham
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

Thanks in advance

1 Solution

Accepted Solutions
YoussefBelloum
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
YoussefBelloum
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
MVP

Re: Percentage calculation help

try with total

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

What does the TOTAL qualifier do?

omarbensalem
Esteemed Contributor

Re: Percentage calculation help

I would add {<Product>}

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


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

mahitham
Contributor

Re: Percentage calculation help

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


Thanks for your help.