# QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for
Did you mean:
Contributor III

## Restrict data shown in Tablebox

Hello,

I have a query with QlikView.

I would like to apply the following criteria to my table box so that it only displays the sales which have CNR greater than 50 and AUM greater than 25. Please see sample data below.

Sales MemberProductCNRAUM
Sales1Product12030
Sales 2Product23040
Sales 3Product37030

So ideally only the data in bold should be shown as it meets the criteria.

Many thanks,

Esther

1 Solution

Accepted Solutions
Champion III

As peter suggested you cant use Tablebox to reduce data. Try below using straight table chart.

Dimensions : Sales Member, Product

Expr1: = Sum({< CNR = {'>50'}, AUM = {'>25'} >}CNR)

Expr2: = Sum({< AUM = {'>25'}, CNR = {'>50'} >}AUM)

17 Replies
Partner

CNR greater than 50? That's not what your picture shows.

Moreover, Table Boxes cannot be made to do that. They're just a bunch of glued-together listboxes without the option to enter expressions. Change your Table Box into a straight table, and include a dummy expression. You can now use Calculated Dimensions to specify the values to skip, or use set analysis to do the same.

Champion III

As peter suggested you cant use Tablebox to reduce data. Try below using straight table chart.

Dimensions : Sales Member, Product

Expr1: = Sum({< CNR = {'>50'}, AUM = {'>25'} >}CNR)

Expr2: = Sum({< AUM = {'>25'}, CNR = {'>50'} >}AUM)

Contributor III

hello esther da-silva

for this u can  use set analyis in straight table

Sum({< CNR = {'>50'}*AUM = {'>25'} >}CNR)

Sum({< AUM = {'>25'}* CNR = {'>50'} >}AUM)

hope this will help u

regards

rohit lohani

Contributor III
Author

Hi Peter,

Yes my mistake, sales 3 should have been bold instead. I will try the straight table.

Contributor III
Author

Hi Vishwarath,

Thank you for your response, I tried the above expression but there was an 'error in set modifier expression'.

Kind regards,

Esther

Champion III

It worked for me with the same data i copied. Do you want to show where you getting the problem or show your set analysis expression?

Contributor III
Author

Hello,

I applied your expression to my actual field names. Please se error message below.

Contributor III
Author

There was an error in the above expression.

Champion III

You have an extra CNR in your expression. Try this

= Sum({< "CNR (\$M)" = {'>50'}, "AUM (\$MM)" = {'>25'} >} "CNR \$(M)" )