Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

vireshkolagimat
Contributor III

count of customers contributing 5% sales

HI All,

I would like to know how we can show the the no of customers whose are contributing 5% sales to the total sales in text object.

I know that we can achieve the same in straight box by limiting the dimensions but  i need to show it in text object.

Thank you.

Regards,

Viresh

Labels (2)
2 Replies
ignacio_pena
New Contributor III

Re: count of customers contributing 5% sales

Hi,

For this example:

LOAD * INLINE [
Client, Units_sold
1, 600
2, 20
3, 300
4, 50
5, 200
6, 150];

I have made the following calculations:

Captura.PNG

In the text box is the next expression:

=SUM((if(aggr((sum([Units_sold]) / sum(TOTAL [Units_sold]))*100, Client) >= 5, 1, 0)))

Regards,

 

vireshkolagimat
Contributor III

Re: count of customers contributing 5% sales

Hi, Thank you. 

Will check and let you know.