Restrict data shown in Tablebox

[Anonymous]

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 Member	Product	CNR	AUM
Sales1	Product1	20	30
Sales 2	Product2	30	40
Sales 3	Product3	70	30

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

Many thanks,

Esther

[Peter_Cammaert]

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.

[vishsaggi · Accepted solution]

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

Add Straight table with

Dimensions : Sales Member, Product

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

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

[Anonymous]

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

[Anonymous]

Hi Peter,

Thank you for your response.

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

[Anonymous]

Hi Vishwarath,

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

Kind regards,

Esther

[vishsaggi]

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?

[Anonymous]

Hello,

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

[Anonymous]

There was an error in the above expression.

[vishsaggi]

You have an extra CNR in your expression. Try this

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