Row Count with filter

building reports webintelligence legacy
1

Hi,

Can anybody tell me how we count the NUmber of Rows in a table if we apply a filter to a particular Report Tab.All the other Tabs does not have report filter and retrieve all the rows.

Thanks,
Raj

BOConsul :canada: (BOB member since 2005-01-12)

2

Hi,

When you have a filter, if you are using RowIndex to count the rows in a table, then it gives only the row numbers in a sequential order for the rows displayed.

What exactly you are looking for, even if you apply the filter you need the count of rows to be same as the one without filter?? Can you be more specific or give some more detail for someone to help.

ravi.

palepuravi :india: (BOB member since 2003-10-28)

3

i think i understood your problem. just right click on the column to which you need to count. Go to Calculations>>Count. Now you can see the count of the rows which are filtered. Now, select the cell which shows you this count and try to change the formulae of it in formula section to =NoFilter(Count()). Now, you can see the count with out filter. Isn’t it??

venira :india: (BOB member since 2004-12-07)

4

Hi Ravi,

   The usual of counting the number of rows is to use the count function on any dimension.when you use a report filter filter for a particular tab,i f you use the count function it gives only the number of rows retrieved from the database and not the one which is filtered in that particular tab.

for example when you are applying a filter for the month of january you would get only 15 rows.so i should display.

Number of Rows:15

when you are not using the filter it gives all month values and number of rows might be more than 100.

How do you incorporate that in web1 6.5.I guess Nofilter condition would not be helpful.

Thanks
Raj

BOConsul :canada: (BOB member since 2005-01-12)

5

Hi All,

I keep seeing in posts like this one in the WebI forum to solve various issues by using a nofilter() function. Am I missing something? I am under the impression that there is NOT a nofilter() function in WebI…

If there is or if you know of a workaround for the fact that there isn’t then pls share…

Thx,
GW

geowickey (BOB member since 2005-04-09)

6

Hi,

I tried this.

  1. I have atable with Country, Resort and revenue
  2. want to apply a filter on Country=US
    3.I created a boolean variable “bool” with formula [Country]=“US”
    4.I use this variable to apply a filter(report filter). Saying bool=1
    5.The table is now filtered showing only rows where country=US.
    6.For count replace with formula =(Count([bool] In Report;All))

You will get the actual number of rows.

bosavvy (BOB member since 2005-05-03)

7

Hi bosavvy,

  Thats a good work around for COUNT with nofilter functionality. But is it possible to have SUM with ALL keyword to get the functionality of nofilter function in WebI.

  I mean we have a report table which has a filter to restrict the top 10 cities. Now users need the percentage of these cities contribution compared to all the cities. This is acheivable in FC reporting as there is a NoFilter function to do it.

Can somebody suggest how this can be acheived in WebI.

Thanks

Ravi.

palepuravi :india: (BOB member since 2003-10-28)