Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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

17 Replies
vishsaggi
Champion III
Champion III

Try this

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

Anonymous
Not applicable
Author

The expression is ok now thank you

vishsaggi
Champion III
Champion III

Cool. Can you close the thread accordingly.

Anonymous
Not applicable
Author

The formula appears to work but it does not match the data that that I used to cross check the result in my excel file

Anonymous
Not applicable
Author

For example I am getting 0's under the AUM field where there should be figures

vishsaggi
Champion III
Champion III

can you share a sample qvw file to look into and your expected output based on your original data.

Anonymous
Not applicable
Author

I got it to work now, thank you

Anonymous
Not applicable
Author

It was an issue with my data source. Thanks