topic Re: Limiting values included in a chart in QlikView

Limiting values included in a chart

Anonymous — Tue, 17 Oct 2017 14:01:53 GMT

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

Re: Limiting values included in a chart

Or — Tue, 17 Oct 2017 14:06:01 GMT

Have a look at some Set Analysis resources:

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

A Primer on Set Analysis

Re: Limiting values included in a chart

pradosh_thakur — Tue, 17 Oct 2017 14:06:23 GMT

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

Re: Limiting values included in a chart

Anonymous — Tue, 17 Oct 2017 14:09:10 GMT

Hi Pradosh,

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

Best regards,

Alex.