Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Can any one please help me, how to create a column with % as shown in the attachment.
I'm not able to create % of Compliant and % of Non-Complaint
Logic for Compliant and Non-Compliant
% of Compliant = Compliant total / (Compliant total + Non-Compliant total)
% of Non-Compliant = Non-Compliant total / (Compliant total + Non-Compliant total).
When I create a new expression, it applies to all other measures and dimensions.
I looking to replicate the same thing in qlik sense.
Thanks in Advance.
Regards
Arjun.
It depends on what your data looks like, and which dimensions you use in the chart...
If you have a field "IsCompliant" that can be True/False, and you want to count an "ID", then you could use the following:
Compliant: Count(distinct {$<IsCompliant={-1}>} ID)
Non-Compliant: Count(distinct {$<IsCompliant={0}>} ID)
Compliant %: Count(distinct {$<IsCompliant={-1}>} ID) / Count(distinct ID)
Non-Compliant %: Count(distinct {$<IsCompliant={0}>} ID) / Count(distinct ID)
HIC
... and if you use the field "IsCompliant" as dimension in your chart, you could use
Count: Count(distinct ID)
Count %: Count(distinct ID) / Count(distinct total <IsCompliant> ID)
HIC
Hi Henric,
Apologies for the delay response.
In the presentation, I'm taking multiple dimensions.
If I give one expression its working fine (value), but when I add one more expression (percentage).
It applies the % expression to all the dimensions.
Kindly find the attached image for your reference.
Thanks in Advance.
Regards,
Arjun.