topic accumulate the sales in QlikView

accumulate the sales

Sun, 24 Aug 2014 09:43:08 GMT

hi all,

i have a straight table which shows customers versus their sales

Customer

Sales

Customer A

100

Customer B

120

Customer C

300

Customer D

230

The total sales here is 750

i want to add a slider and the user to select the value accumulate to the total sales is colored with red

i.e if the customer select 40 from the slider that means hw wants to give a red color to customers who accumualte to 40% of total sales which is 40*750/100=300

so, customer A,Customer B and Customer C will be highlighted by Red Color

how to make this??

Re: accumulate the sales

MarcoWedel — Sun, 24 Aug 2014 10:28:21 GMT

why do customer A,Customer B and Customer C accumulate to 40% of total sales?

Is it because of the order in this table? Does this mean, customers sorted by name do have to accumulate to 40%?

please clarify.

thanks

regards

Marco

Re: accumulate the sales

Sun, 24 Aug 2014 10:31:58 GMT

yes, it's according to their sort

Re: Re: accumulate the sales

antoniotiman — Sun, 24 Aug 2014 13:38:50 GMT

Hi Mona,

see attachment.

Regards,

Antonio

Re: accumulate the sales

MarcoWedel — Sun, 24 Aug 2014 14:40:19 GMT

Hi,

one solution:

hope this helps

regards

Marco