Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

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


1 Solution

Accepted Solutions
luisccmm
Contributor

Re: QlikSense Total Percentage

A jobmate has gave me the solution.

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

5 Replies
MVP
MVP

Re: QlikSense Total Percentage

May be try this

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

luisccmm
Contributor

Re: QlikSense Total Percentage

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

MVP
MVP

Re: QlikSense Total Percentage

How about this

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

luisccmm
Contributor

Re: QlikSense Total Percentage

I get NULL values with that expression.

luisccmm
Contributor

Re: QlikSense Total Percentage

A jobmate has gave me the solution.

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

Community Browser