topic Re: listbox expression? in QlikView

listbox expression?

Wed, 03 Dec 2014 16:09:04 GMT

Hi i have 2 dimensions, product,sales

product:

apple

banana

mango

orange

sales:

100

200

300

400

dimension is product and sum(sales) as expression in barchart .

here my req is when i click on mango selections should not happen?need to show orange sales(400) not mango

for orange, orange sales only

it means i want delete the record called mango here ? how to delete record in listbox?

Re: listbox expression?

its_anandrjs — Wed, 03 Dec 2014 17:07:54 GMT

Hi,

There are two ways for this

1. Create the list box by ignoring the mango selection and do not load in the list box by using calculated dimensions in the properties of the list box expression

=if(product<>'mango',product)

2. In the Bar chart use expression

=if(GetFieldSelections(product)='mango',Sum({<product={'orange'}>}sales),Sum(sales))

Regards

Anand