Limiting values included in a chart

[Anonymous]

I am currently working on a KPI dashboard using data extracted directly from SAP.

The issue I am having is although it is great to be able to access all of my required data in pretty much one file, I have so much data, I now need to seriously restrict the data that is being used.

Further on this, I also need to be able to have different restrictions in different charts within the same application.....interesting.

Example:

Source data has 170,000 lines, I only want the orders that were created 2016-Onwards, therefore what expression would I require to add to the 'CREATION DATE' column would be?

Source data has 170,000 lines, I only want lines that have a certain order type specified in the 'ORDER TYPE' column, and this is "EXAMPLE", what expression would I use to only see 'EXAMPLE' order types?

Thank you

[Or]

Have a look at some Set Analysis resources:

https://community.qlik.com/docs/DOC-4951

A Primer on Set Analysis

[pradosh_thakur · Accepted solution]

try something similar

1:In the script write something like

where "CREATION DATE' >='01-01-2016'  check your date format

else use similar thing using set analysis

2: If(MATCH([ORDER TYPE],'example'),[ODRER TYPE],NULL())  in the expression

[Anonymous]

Hi Pradosh,

Thank you very much this has worked with a little bit of tweaking to match the formats I have!

Best regards,

Alex.