Selection Criteria

[#1]

I wanted to know the easiest way to only show the records from my data that are greater than a specific dollar amount.  Do I use a function or create a dimension?  thanks

[sujeetsingh]

RawData:

load

ID

,Values

,SaleDate

from ecel file:

Table2:

load ID

,Values

,SalesDate

,if(ID>8 and Year(SalesDate)='2013',1,0) as IncludeFlag

resident RawData:

Drop table RawData:

//----------------now from here you can just restrict the Include Flag =1 in Your UI -------------Or in script you have to move one step ahead--//

MainData:

load ID as CustomerID

,Values

,SalesDate

, IncludeFlag

resident Table2 where exsist(IncludeFlag=1);

drop table Table2;

try this

[tresesco]

I guess, using set analysis would be better. Like: Sum( {<Amount={">100"}> Amount}, this expression would reduce your data set accordinly irrespective of your dimension restriction. And yes, if you are sure that those amounts are never going to be used in the UI reporting, better put a where clause in the script to exclude them during load. That would be more meaningful.

Load Field1,

          Amount

From <> where Amount>100;

[#4]

thanks very much for all your help - really appreciate it