Skip to main content
Announcements
Customer Spotlight: Discover what’s possible with embedded analytics Oct. 16 at 10:00 AM ET: REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Limiting values included in a chart

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

1 Solution

Accepted Solutions
pradosh_thakur
Master II
Master II

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

Learning never stops.

View solution in original post

3 Replies
Or
MVP
MVP

Have a look at some Set Analysis resources:

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

A Primer on Set Analysis

pradosh_thakur
Master II
Master II

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

Learning never stops.
Anonymous
Not applicable
Author

Hi Pradosh,

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

Best regards,

Alex.