Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
luisccmm
Creator
Creator

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
Creator
Creator
Author

A jobmate has gave me the solution.

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

View solution in original post

5 Replies
sunny_talwar

May be try this

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

luisccmm
Creator
Creator
Author

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

sunny_talwar

How about this

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

luisccmm
Creator
Creator
Author

I get NULL values with that expression.

luisccmm
Creator
Creator
Author

A jobmate has gave me the solution.

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