Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
Percentage:
=Count(distinct id)/Count(distinct total id)
on the number tab, on the expression check "show in percentage %"
Hi,
Percentage:
=Count(distinct id)/Count(distinct total id)
on the number tab, on the expression check "show in percentage %"
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)
Yes Omar you are right with out {<Product>} getting 100% while selecting any specific product.
Thanks for your help.