sales 100%?

[#1]

i have listbox  called   status 

status:

statusA

statusB 

i have a chart with dimension as  status  and  expression as   sum(sales)  

my req is  when i click on statusA  i want see  100% sales  and when  statusB i want see 50% sales   how?

Thanks in advance

[qlikoqlik]

Hi Manoj

Use set analysis

=if(Status = 'StatusA', sum(sales),

if(Status = 'StatusB', sum(sales)/2))

Thanks and regards

PAdma