Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Selection Criteria

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

3 Replies
sujeetsingh
Honored Contributor III

Re: Selection Criteria

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

MVP
MVP

Re: Selection Criteria

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;

Not applicable

Re: Selection Criteria

thanks very much for all your help - really appreciate it

Community Browser