topic Re: set analysis expression in QlikView

set analysis expression

Tue, 25 Feb 2014 16:14:22 GMT

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!

Re: set analysis expression

Nicole-Smith — Tue, 25 Feb 2014 16:20:57 GMT

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

Re: set analysis expression

agilos_mla — Tue, 25 Feb 2014 16:22:11 GMT

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

Re: set analysis expression

greg-anderson — Tue, 25 Feb 2014 16:38:00 GMT

This is the format that has worked best for me.

Re: set analysis expression

Tue, 25 Feb 2014 19:22:49 GMT

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.

Re: set analysis expression

santharubban — Tue, 25 Feb 2014 21:00:16 GMT

try this

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

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