topic Re: Exclude data from an expression in App Development

Exclude data from an expression

Lilla_Szabo — Fri, 15 Nov 2024 21:06:38 GMT

Hello,

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

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! 🙂

Re: Exclude data from an expression

RafaelBarrios — Thu, 18 Jan 2024 17:51:57 GMT

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! 😎

Re: Exclude data from an expression

hic — Thu, 18 Jan 2024 17:56:24 GMT

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