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

[vishsaggi]

Try this

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

[Anonymous]

The expression is ok now thank you

[vishsaggi]

Cool. Can you close the thread accordingly.

[Anonymous]

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]

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

[vishsaggi]

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

[Anonymous]

I got it to work now, thank you

[Anonymous]

It was an issue with my data source. Thanks