sales 100%?

Sat, 02 Aug 2014 12:39:40 GMT

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

Re: sales 100%?

qlikoqlik — Sat, 02 Aug 2014 12:49:46 GMT

Hi Manoj

Use set analysis

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

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

Thanks and regards

PAdma