topic Re: Exclude data (Straight Table) in QlikView

Exclude data (Straight Table)

hkg_qlik — Tue, 08 Oct 2013 19:54:43 GMT

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,

Re: Exclude data (Straight Table)

Anonymous — Tue, 08 Oct 2013 20:15:36 GMT

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

Re: Exclude data (Straight Table)

hkg_qlik — Tue, 08 Oct 2013 20:28:11 GMT

Michael,

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

Thanks,

Re: Exclude data (Straight Table)

Anonymous — Tue, 08 Oct 2013 20:32:46 GMT

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

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

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

Re: Exclude data (Straight Table)

2908nmadao — Wed, 21 Jan 2015 17:05:39 GMT

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

Re: Exclude data (Straight Table)

Anonymous — Wed, 21 Jan 2015 17:43:19 GMT

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)

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

Re: Exclude data (Straight Table)

2908nmadao — Thu, 22 Jan 2015 09:18:16 GMT

Thank you so much Michael! Very helpful!

Cheers.