Exclude a specific value from a dimension's field

[PaoloGuerra]

Hi All,

I have a dimension with a lot of values.

The name of dimension is "DB_User_Name_Comb_Machine_Learning".

I need to exclude a value with the name "DB_User_Name"

In the expression I have used "not Match", but it doesn't work.

DB_User_Name_Comb_Machine_Learning
If(not Match(DB_User_Name_Comb_Machine_Learning, 'DB_User_Name'),DB_User_Name_Comb_Machine_Learning)

Can you help me please?

[Vegar]

Instead of manipulating the dimension you could just exclude the value from your expressions with SET analysis.
Try adding the set {$<DB_User_Name_Comb_Machine_Learning-={"DB_User_Name"}>} into your expressions.
SUM(AMOUNT) would become
SUM({$<DB_User_Name_Comb_Machine_Learning-={"DB_User_Name"}>}AMOUNT)

[PaoloGuerra]

Hi @Vegar

sorry, but i don't understand.

I've 1 dimension and 6 measures with its expressions

Should i add this code in all expressions of the measures? 

{$<DB_User_Name_Comb_Machine_Learning-={"DB_User_Name"}>}

Then, I don't understand where I can add this code:

SUM({$<DB_User_Name_Comb_Machine_Learning-={"DB_User_Name"}>}AMOUNT)

Thanks

[Vegar]

You should i add this code in all expressions of the measures?

{$<DB_User_Name_Comb_Machine_Learning-={"DB_User_Name"}>}


The code below was just an example on where inside your expressions you
should put the SET .
SUM( {$<DB_User_Name_Comb_Machine_Learning-={"DB_User_Name"}>} AMOUNT)

Before implementing my suggested solution I would recommend you to read
this Qlik help page:
https://help.qlik.com/en-US/sense/November2018/Subsystems/Hub/Content/Sense_Hub/ChartFunctions/SetAn...

[lfetensini]

Hello Friend.

From what I understand, you're creating an expression to limit the content of your dimensions. As if it were a calculated dimension.

If yes, use the simple following formula:

If (DB_User_Name_Comb_Machine_Learning <> 'DB_User_Name', DB_User_Name_Comb_Machine_Learning)

[PaoloGuerra]

Hi @Vegar

I can't add the code because there is an error.

This is the expression on the first measure

Count({<High_volume_Outlier_Comb_Machine_Learning={"True"}>}High_volume_Outlier_Comb_Machine_Learning)
{$<DB_User_Name_Comb_Machine_Learning-={"DB_User_Name"}>}

Error into expression

[lfetensini]

Are you trying apply two filters in Set Analisys? If yes, try:

Count(
{<
High_volume_Outlier_Comb_Machine_Learning = {"True"},
DB_User_Name_Comb_Machine_Learning -= {"DB_User_Name"} // Second filter after comma
>}
High_volume_Outlier_Comb_Machine_Learning
)

[Vegar · Accepted solution]

You should put both SET modifiers into one expression. Please take a look
at the expression below.

Count({<
High_volume_Outlier_Comb_Machine_Learning={"True"},
DB_User_Name_Comb_Machine_Learning-={"DB_User_Name"}
>}High_volume_Outlier_Comb_Machine_Learning)

[moumita]

Hi, 

Please try below code in the expression editor to exclude DB_User_Name from DB_User_Name_Comb_Machine_Learning:-

if(DB_User_Name_Comb_Machine_Learning<>DB_User_Name,DB_User_Name_Comb_Machine_Learning)