Forum Discussion
RichFlorida
Helper V
Helper VPage filter with two conditions
I have the following SQL statement with an OR condition impacting two different columns: Select *
From tableA
Where (DeptName is not Null OR DivisionName is not Null) How do I add thi...
hi RichFlorida ,'
there is "AND" / "OR" selection right under null.
select "And" , drop in the other required field and condition similar to the steps above.
Hi RichFlorida ,
You can try this measureIncludeMeasure = IF(NOT(ISBLANK(MAX([DeptName]))) || NOT(ISBLANK(MAX([DivisionName]))), 1, 0)or
Create a Calculated Column:
IncludeRow = IF(NOT(ISBLANK([DeptName])) || NOT(ISBLANK([DivisionName])), 1, 0)Add a Table Visual:
- Go to the Report view.
- Add a new table visual to your report.
Add Fields to the Table Visual:
- Drag and drop the fields you want to display from your table into the table visual.
- Drag and drop the IncludeRow column into the Filters pane of the visual.
- Set the filter condition to show rows where IncludeRow is 1.
manvishah17
Solution Supplier
Solution SupplierHi RichFlorida ,
You can try this measure
IncludeMeasure = IF(NOT(ISBLANK(MAX([DeptName]))) || NOT(ISBLANK(MAX([DivisionName]))), 1, 0)
or
Create a Calculated Column:
IncludeRow = IF(NOT(ISBLANK([DeptName])) || NOT(ISBLANK([DivisionName])), 1, 0)Add a Table Visual:
- Go to the Report view.
- Add a new table visual to your report.
Add Fields to the Table Visual:
- Drag and drop the fields you want to display from your table into the table visual.
- Drag and drop the IncludeRow column into the Filters pane of the visual.
- Set the filter condition to show rows where IncludeRow is 1.