Exclude data from an expression

[Lilla_Szabo]

Hello,

is it any possibility to exclude a sub-set of data from an Expression in QlikView ?

I would like to exclude CountryCode='IN' from Region='APJI'. 

=num(Count(DISTINCT(if(INPR?='INPR' and Group='VEND' and Team = 'INPR' and Region = 'APJI'
and [Calendar Day]+'1' <=[Change Date],([Vendor])))),'#,##0')

(Below the Region of APJI there are a lot of CountryCodes, but I only want to exclude India 'IN' in one object/table. I can not move it from the script, because I will need Region field APJI as a whole for the other objects/tables.)

Thank you in advance for the help! 🙂

[RafaelBarrios]

hello @Lilla_Szabo 

you should try setanalysis instead of IF in formulas

the following exclude India

=Count(DISTINCT {< INPR?={'INPR'},Group={'VEND'},Region={'APJI'},Team={'INPR'},Region{'APJI'},Country=-{'IN'} >} [Vendor])

or you could combine o exclude part of the Sets

count({<SET1>-<SET2>} sales)

=Count(DISTINCT {< INPR?={'INPR'},Group={'VEND'},Team={'INPR'}  > - < Region={'APJI'}, Country={'IN'}  >} [Vendor])

think it this way

Hope this helps.

best,

help users find answers! Don't forget to mark a solution that worked for you & to smash the like button! 😎

[hic]

Take a look at https://community.qlik.com/t5/Design/Excluding-values-in-Set-Analysis/ba-p/1471704