Exclude data (Straight Table)

[hkg_qlik]

Hi all,

I would like to exclude some data in a straight table based on Employer Name.

For example: I have 10 employers and I only want the straight table chart to display only 7 employer's information. Want to exclude employer A, B and C.

How it can be achieved on the front end (Straight Table). Do i use a calculated dimension or write an expression?

Can anyone help me with the syntax in either case?

Regards,

H

[Anonymous · Accepted solution]

I'd rather use calculated dimension because you do it one palce.  If in expressiosn - you have to use conditions in each expression. Syntax for calculated dimension:

aggr(only({<Employer-={'A','B','C'}>} Employer),Employer)

or if you prefer "if"

aggr(if(match(Employer,'A','B','C')=0, Employer),Employer)

In any case, check "suppress when value is null"

Regards,

Michael

[hkg_qlik]

Michael,

Thanks for sharing your idea. Can you please give an expression syntax too for future reference.

Thanks,

H

[Anonymous]

It depends on expression.  For example, if it is sum(Amount), you'll have to change it to

sum({<Employer-={'A','B','C'}>} Amount)

or

sum(if(match(Employer,'A','B','C')=0, Amount))

[2908nmadao]

Hi all,

I need some help.I have a similar issue.

I want to exclude some of my entrances in a table.

I have a Status table with Open, Closed, Cancelled, etc

I would like to make an expression to Exclude Closed, Cancelled, Completed so that I would have visibility of the open records only.

Thanks in advance

Kind regards

Nelson

[Anonymous]

Nelson,

In your case it is easier to specify what to include than what to exclude, because there is only one value to include.  Expression will be something like this:

sum({<Status={'Open'}>} Amount)

or

sum(if(Status='Open', Amount))

[2908nmadao]

Thank you so much Michael! Very helpful!

Cheers.