This content has been marked as final.
Show 2 replies
-
1. Re: Vectorwise and Top N Filter
Tracy RodgersSep 12, 2012 9:12 AM (in response to . Pinongs)
Hi Pinongs,
This is a known issue where the TOP query is not supported by the database itself (i.e. Vectorwise).
One way to get around this is to sort the field first (right click on it in the view and select Sort... By Field, etc). Then, create a calculated field similar to the following, place it on the filter shelf and select 'True':
index()<=10
Depending on how the view is set up, it may be necessary to change the way the calculation is computed (to do this right click on it and select Compute Using...)
Hope this helps!
-Tracy
-
2. Re: Vectorwise and Top N Filter
. Pinongs Sep 12, 2012 6:03 PM (in response to Tracy Rodgers)Thanks for the workaround.