How to limit data in table

[#1]

Hi

I'm new to qlik and just wanted to know if there is a way to limit the data shown in the table to PO Amounts over $5,000 that were not approved by either the Financial Controller or Purchasing Officer

Thanks

[prieper]

You may simply put this as your expression (aircode):

IF(SUM(IF(MATCH([Approved By Position], 'Purchasing Officer', 'Financial Controller), [Purchase Order Amount]) > 5000, SUM(IF(MATCH([Approved By Position], 'Purchasing Officer', 'Financial Controller), [Purchase Order Amount]))

Peter

[Anonymous · Accepted solution]

Hi,

It may be like this below

Sample Data

Sample App

Code used in expression

Store person is not reflected in sample application as per your requirement. Also you need to exclude null values in your dimension

Thanks!

Sharanya

[#4]

Thanks for your help