# New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

## Percentage and Values in Pivot Table

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.

Regards

Arjun.

3 Replies
Employee

## Re: Percentage and Values in Pivot Table

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

Employee

## Re: Percentage and Values in Pivot Table

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

Not applicable

## Re: Percentage and Values in Pivot Table

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.