set analysis expression

[#1]

Hi,

I've created an expression in a pivot table chart where I limit the data to only certain types of sales:

count({$<sales = {'NorthAmerica'}>}sales)

I want to expand this expression to NOT include a certain type of sale,something like this

Count({$<'Category ID' <> {'1'}>}'Category ID')

How do I combine these into one expression? 

Thanks!

[Nicole-Smith]

count({$<sales = {'NorthAmerica'}>-<[Category ID]={1}>}sales)

[agilos_mla]

Hi Brian,

Try :

count({$<sales = {'NorthAmerica'}, [Category ID]-={'1'}>}sales)

You can use multiple conditions in the set analysis separated by comma. Here to exclude the category ID I use the minus sign before the ={'1}.

Michael

[greg-anderson]

This is the format that has worked best for me.

[#5]

You can have a look at the Qlikview video here http://www.youtube.com/watch?v=8olMt2AOUJ8 and it will help you to solve your problems. I gained a lot learning from these session videos available on the net and cleared many doubts that I had in Qlikview and build a strong foundation.

[santharubban]

try this

count({$<sales = {'NorthAmerica'}, [Category ID]={'<>(1)'}>}sales)

or

count({$<sales = {'NorthAmerica'}, [Category ID]={"<>(=1)"}>}sales)