Filter Condition

Filter Condition: This video contains how to use filter conditions in AIV.

• This document is all about how to use Filter Condition function in AIV. By using this function user can filter the data in a widget that fulfills the condition which user set in the filter setting.

Use Case: Filter the data of the table widget with reference to the condition applied in the filter setting.

1. Log in to the AIV application with your credentials & create a new dashboard named ‘Filter Condition’.
2. From the left Vertical Menu of the dashboard create a table widget & enter below details in the edit menu of it:

• Dataset: Sales.ds
• Dataset Columns: Select country, countrycode, quantity Ordered from the Dataset Columns.

3. Click on Preview & Save and Exit button.
4. Go to Filter icon from the top right corner of the dashboard & click on (+) icon to create filter.
5. Write QuantityOrdered in the Name box & click on check option, your filter will be created.
6. Open Filter Widget menu by clicking on setting icon & fill the below given details:

• Source: Dataset
• Datasets: Sales.ds
• Condition: Greater than or Equal
• Column Name: quantityOrdered

7. Go to Link Filters & Widgets tab & selects the below details:

• Layer: Layer 1
• Tabs: Tab 1
• Widgets: Table Widget 1
• Select quantityOrdered from the available columns

8. Go to Filter View tab & click on (+) icon to add filter in the dashboard.
9. Click on Save and Exit button & go to Preview mode from the top right corner of the dashboard.
10. In filter select 45 from the drop-down & click on Filter button. Output will look as per the image below:

• Note: It will show the data equal to 45 & above in quantity Ordered as we selected condition Greater than or Equal in filter setting.

11. Click on Edit Menu of the dashboard & go to filter widget setting.
12. Select Less than from the drop-down of the Condition option & click on Save and Exit button.
13. Preview the dashboard & in filter select 12 from the drop-down and click on Filter button, Output will look as per the image below:

• Note: It will show the data below 12 in quantity Ordered as we selected condition Less than in filter setting.

14. Click on Edit Menu of the dashboard & go to filter widget setting.
15. Select Less than or Equal from the drop-down of the Condition option & click on Save and Exit button.
16. Preview the dashboard & in filter select 13 from the drop-down and click on Filter button, Output will look as per the image below:

• Note: It will show the data below or equal to 13 in quantity Ordered as we selected condition Less than or Equal in filter setting.

17. Click on Edit Menu of the dashboard & go to filter widget setting.
18. Select Equal to from the drop-down of the Condition option & click on Save and Exit button.
19. Preview the dashboard & in filter select 37 from the drop-down and click on Filter button, Output will look as per the image below:

• Note: It will show only 37 in quantity Ordered as we selected condition Equal to in filter setting.

20. Click on Edit Menu of the dashboard & go to filter widget setting.
21. Select Greater than from the drop-down of the Condition option & click on Save and Exit button.
22. Preview the dashboard & in filter select 70 from the drop-down and click on Filter button, Output will look as per the image below:

• Note: It will show data greater than 70 as we selected Greater than condition in filter setting.

23. Delete the filter from the ellipses of the filter.
24. Go to filter icon from the top right corner of the dashboard to create a new filter.
25. Create new filter as you created earlier & give name country to it.
26. Go to Filter Widget by clicking on setting button & enter below details:

• Source: Dataset
• Datasets: Sales.ds
• Display Type: Multi Select
• Condition: In
• Column Name: country

27. Go to Link Filters& Widgets tab & selects the below details:

• Layer: Layer 1
• Tabs: Tab 1
• Widgets: Table Widget 1
• Select country from the available columns

28. Go to Filter View tab & click on (+) icon. Click on Save and Exit button.
29. Click on Preview icon from the top right corner of the dashboard.
30. Select USA & Denmark in the filter & click on Filter button.
31. Output will look as per the image below:

• Note: Table widget will show the filtered data of USA & Denmark as we applied the In condition.
• In Condition: When user selects more than one country (column data), it will show the filtered data of that selected country (column data).

32. Click on Edit Menu of the dashboard & go to filter setting.

33. Select Not In from the drop-down of the Condition option & click on Save and Exit button.

34. Preview the dashboard & select USA & Spain from drop-down of the filter and click on Filter button, Output will look as per the image below:

• Note: Table widget will show the filtered data all country except USA & Spain.
• Not In Condition: When user selects more than one country (column data), it will show the filtered data all other country (column data) except selected country (column data) in filter.

35. Delete the filter from the ellipses of the filter.
36. Now again go to filter icon from the top right corner of the dashboard to create a new filter.
37. Click on (+) icon & name the filter country1.
38. Got to the Filter Widget by clicking on setting button & enter the below details:

• Source: Static
• Display Type: Text Box
• Condition: Like

39. Go to Link Filters and Widgets tab & select details as given below:

• Layer: Layer 1
• Tabs: Tab 1
• Widgets: Table Widget 1
• Select country from the available columns

40. Go to Filter View tab & add it in dashboard as we did earlier.
41. Click on Save and Exit button & Preview icon of the dashboard.
42. In Filter text box write er & click on Filter button. Output will look as per below:

• Note: Table widget will show the data of country which have e & r letters respectively in their words.

43. Edit the dashboard & go to filter setting.
44. Select Not Like from the drop-down & Click on Save and Exit button.
45. Go to Preview mode of the dashboard.
46. Write US in the filter text box & click on Filter button. Output will look as per below:

• Note: Table widget will show the data of country do not have U & S letters respectively in their words.