Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Not applicable

Set Analysis <> function

Hi,

I have a formula that filters the products by those labelled as "Other" amoung the BrandNames included (real brands are changed to protect the guilty) but I want the same formula that excludes products with the description of "Other".

How do I do this, replacing = with <> doesn't work

 

Sum({$<BrandName = {'Shirts','Pants','Hats','Shorts'}, SeasonShort ={"$(vCurrentSeason)"}, Products={'Other'} >} Sales)

Dave

1 Solution

Accepted Solutions
preminqlik
Valued Contributor II

Re: Set Analysis <> function

hi there,

if the above expresssion is doesn't work then  try this below exp :


Sum({$<BrandName = {'Shirts','Pants','Hats','Shorts'}, SeasonShort ={"$(vCurrentSeason)"}, Products= {"*"}-{"Other"} >} Sales)


or

sum(if((BrandName = 'Shirts' or BrandName='Pants' or BrandName='Hats' or 'Shorts') and SeasonShort =vCurrentSeason and Products<>'Other' ,Sales)

2 Replies
preminqlik
Valued Contributor II

Re: Set Analysis <> function

hi there,

if the above expresssion is doesn't work then  try this below exp :


Sum({$<BrandName = {'Shirts','Pants','Hats','Shorts'}, SeasonShort ={"$(vCurrentSeason)"}, Products= {"*"}-{"Other"} >} Sales)


or

sum(if((BrandName = 'Shirts' or BrandName='Pants' or BrandName='Hats' or 'Shorts') and SeasonShort =vCurrentSeason and Products<>'Other' ,Sales)

Not applicable

Re: Set Analysis <> function


This worked, Thanks!

Sum({$<BrandName = {'Shirts','Pants','Hats','Shorts'}, SeasonShort ={"$(vCurrentSeason)"}, Products= {"*"}-{"Other"} >} Sales)

Community Browser