topic Re: QlikSense Total Percentage in App Development

QlikSense Total Percentage

luisccmm — Thu, 15 Feb 2018 16:17:24 GMT

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.

Re: QlikSense Total Percentage

sunny_talwar — Thu, 15 Feb 2018 16:37:26 GMT

May be try this

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

Re: QlikSense Total Percentage

luisccmm — Thu, 15 Feb 2018 16:46:21 GMT

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

Re: QlikSense Total Percentage

sunny_talwar — Thu, 15 Feb 2018 16:48:16 GMT

How about this

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

Re: QlikSense Total Percentage

luisccmm — Thu, 15 Feb 2018 16:54:57 GMT

I get NULL values with that expression.

Re: QlikSense Total Percentage

luisccmm — Fri, 16 Feb 2018 10:00:02 GMT

A jobmate has gave me the solution.

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