topic Re: Suppress records from table based on select fields in QlikView

Suppress records from table based on select fields

Thu, 09 Jul 2015 19:58:08 GMT

I have a table box loaded with all records from database. What I want to do is use select fields to suppress records from the table that meet those criteria. So instead of isolating criteria that meets the selects, I want to suppress those records that meet the selects and just leave those that don't in the table.

As an example - I have a select field: Region. I want to be able to pick "Midwest" region from that select field and the result is all records associated with "Midwest" region are suppressed from the table. Leaving only those records associated with the unselected regions.

I'm sure someone has accomplished this, so if you could point me in the right direction to previous discussions on this or provide the solution you found, that would be great.

Thank you.

Re: Remove records from table based on select criteria

Qrishna — Thu, 09 Jul 2015 20:02:20 GMT

You cannot add expressions or conditions in a table box.

if you want to filter out unwanted data then use St table or pivot table.

you can filter the data only at script level, if you want to use only a table box.

Re: Suppress records from table based on select fields

Thu, 09 Jul 2015 20:33:29 GMT

Krishna,

Thank you for the reply. I've converted the table to a straight table. Now how could I go about using my select field to suppress records from the table?

For example, I have a select field titled "Region". I want to be able to select "Midwest" from the region select group and have all records associated with the "Midwest" region suppressed from the table.

Do you know how to accomplish this?

Re: Suppress records from table based on select fields

Qrishna — Thu, 09 Jul 2015 20:37:43 GMT

Could you please give me some sample data?

Re: Suppress records from table based on select fields

awhitfield — Fri, 10 Jul 2015 09:22:52 GMT

Hi Steve,

See the simple attached qvw, this excludes sales for the selected region and shows everything else, using sum({1 - $} Sales) as the expression.

HTH Andy