Show row if

[NoamRotter]

Hi,

I am new to Qlik sense so I'm sure my question is an easy one.

I have added a table chart with 4 columns

I want to the table to show only rows that the "severity" is "Critical" and "Exploit available" is "yes"

How do I do that?

Thanks in advance 

Noam.

[MatheusC]

@NoamRotter 

If you have a measurement expression, you can limit it directly in the expression ex:

sum({<severity={"Critical"} , Exploit={"yes"}>}totalSale)

Let me know if there are any more details, or if this helps.

Att, Matheus

[jchx]

Hi @NoamRotter 

How I approach these types of requirements is to create master dimensions, as it allows for easier maintenance of the dashboard going forward.

Go to the "Master Items" pane > create 2 new master dimensions with the following expressions:

1) if(match(Severity, 'Critical'), Severity, null())

2) if(match(Exploit Available, 'Yes'),Exploit Available, null())

After this, use these 2 new dimensions in your table instead. Remember to uncheck "Include Null Values" for each dimension.

[anat]

in dimension you can apply below logic for Name field 

if (severity="Critical" and  Exploit="yes",Name)

[Aditya_Chitale · Accepted solution]

Use this expression in the 'Name' Column and uncheck include null values checkbox from this column.

=if(Severity='Critical' and ExploitAvailable='Yes', Name, null())

Regards,

Aditya

[Ahidhar]

try this

if(Severity='Critical' , Severity , null())

if("Exploit Available"='yes' , "Exploit Available",null())

and uncheck include null values

[NoamRotter]

Thank you everyone for replying to my question!

your answers were very helpful!

[NoamRotter]

I liked your approach very much!