Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Suppress records from table based on select fields

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.

4 Replies
krishna_2644
Valued Contributor III

Re: Remove records from table based on select criteria

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.

Not applicable

Re: Suppress records from table based on select fields

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?

krishna_2644
Valued Contributor III

Re: Suppress records from table based on select fields

Could you please give me some sample data?

awhitfield
Esteemed Contributor

Re: Suppress records from table based on select fields

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

Community Browser