topic Re: How to limit data in table in QlikView

How to limit data in table

Wed, 25 Nov 2020 16:16:04 GMT

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

Re: How to limit data in table

prieper — Tue, 09 May 2017 07:20:25 GMT

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

Re: How to limit data in table

Anonymous — Tue, 09 May 2017 14:00:09 GMT

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

Re: How to limit data in table

Sat, 13 May 2017 02:25:28 GMT

Thanks for your help