Skip to main content

👉 Filter Conditions in Adhoc Analysis

  • By following this document user will know how to use Filter Conditions in Adhoc Anaysis.

Prerequisites​

  • This Filter Condition work with pipeline dataset only.

  • For this example we are using Analysis Filter.pipeline.

  • Download jar file from link given Link. After downloading the jar file, add Sales.ds from file into the AIV.

Skill Level Required​

  • No prior knowledge of Adhoc Analysis required but knowladge of binary filter conditions will be advantageous. Click here to know more about Adhoc Analysis in detail.

Steps to create Filter Condition​

  1. Log in to your AIV application using your valid credentils.

  2. Go to hamburger menu Docusaurus Slash Introduction > Document > Adhoc Analysis & click on the + icon to create a new Analysis, as shown in the figure below:

    Docusaurus Slash Introduction

  3. When you click on create Analysis then the Analysis Selection dialog box will open, as shown in the figure below:

    Docusaurus Slash Introduction

  4. In Analysis Selection window fill the dtails as shown in the image below:

  • Datasets: Analysis_Filter
  • Rows: coutry
  • Columns: productLine
  • Values: quantityOrdered (Type:Count)
  • Filters: QuantityOrdered

IN​

  • IN Condition allows user to easily test if an expression matches any value in a list of values.

  1. CLick on setting icon at the Filters option as shown:

    Docusaurus Slash Introduction

  2. Click on ✓ icon & PREVIEW button.

  3. As you click on CANCEL button, the window will look as per the image below:

    Docusaurus Slash Introduction

NOT IN​

  • NOT IN Condition shows the list of values, which is not matched with filtered value.

  1. Now again go to the setting icon at the Filters option with refrence to in step np- 5 & fill the details as shown:

    Docusaurus Slash Introduction

  2. Click on ✓ icon & PREVIEW button.

  3. As you click on CANCEL button, the window will look as per the image below:

    Docusaurus Slash Introduction

NULL​

  • It will display the column name that contains a null value or when a value is missing or unknown.

  1. Now again go to the setting icon at the Filters option with refrence to in step np- 5 & fill the details as shown:

    Docusaurus Slash Introduction

  2. Click on ✓ icon & PREVIEW button.

  3. As you click on CANCEL button, the window will look as per the image below:

    Docusaurus Slash Introduction

NOT NULL​

  • The NOT NULL specification for a column ensures that all fields of that column will contain a value.

  1. Now again go to the setting icon at the Filters option with refrence to in step np- 5 & fill the details as shown:

    Docusaurus Slash Introduction

  2. Click on ✓ icon & PREVIEW button.

  3. As you click on CANCEL button, the window will look as per the image below:

    Docusaurus Slash Introduction

Greater Than​

  • Greater than Condition is used when user wants to see the list of values, which is greater than the filtered value.

  1. Now again go to the setting icon at the Filters option with refrence to step np- 5 & fill the details as shown:

    Docusaurus Slash Introduction

  2. Click on ✓ icon & PREVIEW button.

  3. As you click on CANCEL button, the window will look as per the image below:

    Docusaurus Slash Introduction

Less Then​

  • Less than Condition is used when user wants to see the list of values, which is Less than the filtered value.

  1. Now again go to the setting icon at the Filters option with refrence to step np- 5 & fill the details as shown:

    Docusaurus Slash Introduction

  2. Click on ✓ icon & PREVIEW button.

  3. As you click on CANCEL button, the window will look as per the image below:

    Docusaurus Slash Introduction

LIKE​

  • The LIKE condition allows you to match a string to value. It is a logical operator that checks whether or not a string contains a specified value.

  1. Now add country column in Filters.

    Docusaurus Slash Introduction

  2. Add a condition with refrence to step no- 8 & fill the details as shown:

    Docusaurus Slash Introduction

  3. Click on ✓ icon & PREVIEW button.

  4. As you click on CANCEL button, the window will look as per the image below:

    Docusaurus Slash Introduction

NOT LIKE​

  • It is operators, which are used to find matches between a string and a given pattern.

  1. Now again go to the setting icon at the Filters option as shown in step np- 5 & fill the details as shown:

    Docusaurus Slash Introduction

  2. Click on ✓ icon & PREVIEW button.

  3. As you click on CANCEL button, the window will look as per the image below:

    Docusaurus Slash Introduction

Equal To​

  • This filter option is used to filter columns or columns by their name.

  1. Now again go to the setting icon at the Filters option with refrence to step np- 5 & fill the details as shown:

    Docusaurus Slash Introduction

  2. Click on ✓ icon & PREVIEW button.

  3. As you click on CANCEL button, the window will look as per the image below:

    Docusaurus Slash Introduction

NOT Equal To​

  • This type of filter will work just opposite to Equal to filter. In this Filter type, the condition and value applied will be skipped and the remaining values of the column will be displayed.

  1. Now again go to the setting icon at the Filters option with refrence to step np- 5 & fill the details as shown:

    Docusaurus Slash Introduction

  2. Click on ✓ icon & PREVIEW button.

  3. As you click on CANCEL button, the window will look as per the image below:

    Docusaurus Slash Introduction