Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
estherds
Contributor III
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
vishsaggi
Champion III
Champion III

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)

Capture.PNG

View solution in original post

17 Replies
Peter_Cammaert
Partner
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.

vishsaggi
Champion III
Champion III

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)

Capture.PNG

rohitlohani
Contributor III
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

estherds
Contributor III
Contributor III
Author

Hi Peter,

Thank you for your response.

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

estherds
Contributor III
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

vishsaggi
Champion III
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?

estherds
Contributor III
Contributor III
Author

Hello,

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

estherds
Contributor III
Contributor III
Author

There was an error in the above expression.

vishsaggi
Champion III
Champion III

You have an extra CNR in your expression. Try this

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