Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
Champion III
Champion III

Re: Restrict data shown in Tablebox

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
Highlighted

Re: Restrict data shown in Tablebox

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.

Highlighted
Champion III
Champion III

Re: Restrict data shown in Tablebox

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

Highlighted
Contributor III
Contributor III

Re: Restrict data shown in Tablebox

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

Highlighted
Contributor III
Contributor III

Re: Restrict data shown in Tablebox

Hi Peter,

Thank you for your response.

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

Highlighted
Contributor III
Contributor III

Re: Restrict data shown in Tablebox

Hi Vishwarath,

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

Kind regards,

Esther

Highlighted
Champion III
Champion III

Re: Restrict data shown in Tablebox

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?

Highlighted
Contributor III
Contributor III

Re: Restrict data shown in Tablebox

Hello,

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

Highlighted
Contributor III
Contributor III

Re: Restrict data shown in Tablebox

There was an error in the above expression.

Highlighted
Champion III
Champion III

Re: Restrict data shown in Tablebox

You have an extra CNR in your expression. Try this

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