Discussion Board for collaboration related to QlikView App Development.
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.
For this example:
LOAD * INLINE [Client, Units_sold1, 6002, 203, 3004, 505, 2006, 150];
I have made the following calculations:
In the text box is the next expression:
=SUM((if(aggr((sum([Units_sold]) / sum(TOTAL [Units_sold]))*100, Client) >= 5, 1, 0)))
Hi, Thank you.
Will check and let you know.