Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
mahitham
Creator II
Creator II

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
Champion
Champion

Hi,

Percentage:

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


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

View solution in original post

4 Replies
YoussefBelloum
Champion
Champion

Hi,

Percentage:

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


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

maxgro
MVP
MVP

try with total

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

What does the TOTAL qualifier do?

OmarBenSalem

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
Creator II
Creator II
Author

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


Thanks for your help.