# Qlik Sense App Development

Contributor

## QlikSense Total Percentage

I have the follwing graph created with 1 Measure and 2 Dimensions

Measure

Percentage of Clients

Count(

{< [Money]={">0"}>}

distinct CLientNumber)

/

Count(

{< [IMoney]={">0"}>}

distinct TOTAL CLientNumber)

Dimesion Money Rounded to 50

Round ([MONEY],50)

Dimension Store.

StoreName

The problem I have with that, is that there could be Clients that have paid 50 Euros, but also 80 Euros as well. This makes the Expression to fail, when calculanting this...

Count(

{< [IMoney]={">0"}>}

distinct TOTAL CLientNumber)

The formula (Above in Red) only counts the client One Time, and then the sum of the Percentages that comes from the Dimension Money sums more than 100%.

What I need?

- Percentage of Clients sums 100% for a particular shop, that is the sums of for every MONEY range percentage.

- Preferable solution is that the Dimension, does not work for they MONEY payed in different transactions, rather than that for the SUM of all transactions for every client.

Tags (2)
1 Solution

Accepted Solutions
Contributor

## Re: QlikSense Total Percentage

A jobmate has gave me the solution.

Round (Aggr(sum[MONEY],ClientNumber),50)

5 Replies
MVP

## Re: QlikSense Total Percentage

May be try this

Count({<[IMoney]={">0"}>}DISTINCT TOTAL <Money> CLientNumber)

Contributor

## Re: QlikSense Total Percentage

I didn´t work, still causes to not sums 100%, and sums more.

MVP

## Re: QlikSense Total Percentage

Aggr(NODISTINCT Count({<[IMoney]={">0"}>}DISTINCT CLientNumber), Money)

Contributor

## Re: QlikSense Total Percentage

I get NULL values with that expression.

Contributor

## Re: QlikSense Total Percentage

A jobmate has gave me the solution.

Round (Aggr(sum[MONEY],ClientNumber),50)