topic Selection Criteria in QlikView

Selection Criteria

Mon, 02 Dec 2013 04:27:20 GMT

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

Re: Selection Criteria

sujeetsingh — Mon, 02 Dec 2013 04:46:28 GMT

RawData:

load

,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

Re: Selection Criteria

tresB — Mon, 02 Dec 2013 04:49:15 GMT

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;

Re: Selection Criteria

Mon, 02 Dec 2013 04:57:12 GMT

thanks very much for all your help - really appreciate it