Difference between two variables in set analysis

[shamitshah]

Hi,

I have the following expression which is not giving the right result (trying to find number of stores with no adjustments):

=vNoOfStores-
Count(Distinct{<Department={"=$(vArticleDim)"}>}[%STORE_ID])

where vNoOfStores =Count({1}Distinct(%STORE_ID))   (this expression gives me a result which is the total number of stores)

The expression Count(Distinct{<Department={"=$(vArticleDim)"}>}[%STORE_ID]) on its own gives me no result which is strange given that the first expression gives me a result.

Any ideas?

Thanks

[Gysbert_Wassenaar · Accepted solution]

Try

=$(vNoOfStores)-Count(Distinct{<Department={"=$(vArticleDim)"}>}[%STORE_ID])

[rwunderlich]

Is vArticleDim an article value or a field name? If vArticleDim contains a value you should not use  = within the quotes.  Further, unless you are using wildcards in the search you should use single rather than double quotes. 

Count(Distinct{<Department={'$(vArticleDim)'}>}[%STORE_ID])

-Rob
http://masterssummit.com
http://qlikviewcookbook.com
http://www.easyqlik.com

[shamitshah]

It is actually a  dynamic filter (='Department|Category|"Sub-Category"|ARTICLE_D')

[shamitshah]

Thanks Gysbert. That works.