Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Percent Calculation Function

Is there a function in QV to calculate the % contribution automatically.

I have data by type like

Type     Transactions

A               12

B               10

C               8

I am able to present it via chart however I was trying to present percent contribution instead of actual count

1 Solution

Accepted Solutions
kkkumar82
Valued Contributor III

Re: Percent Calculation Function

OR you can check relative option to your expression Count(Transactions) in expression tab

4 Replies

Re: Percent Calculation Function

May be like this:

Dimension: Type

Expression: Count(Transactions)/Count(TOTAL Transactions)

kkkumar82
Valued Contributor III

Re: Percent Calculation Function

OR you can check relative option to your expression Count(Transactions) in expression tab

Not applicable

Re: Percent Calculation Function

Thanks Sunny

Not applicable

Re: Percent Calculation Function

Thanks Mr. Kumar!!

Community Browser