topic Filters in backend script in QlikView

Filters in backend script

Wed, 13 Aug 2014 10:29:48 GMT

Dear All,

I have to create an filter in the back end script where i want data as per the today and 100 days back data..

I have a date column as DATE([Main Date]) as [Main Date]..

What should i have to do...?

tresB — Wed, 13 Aug 2014 10:35:06 GMT

Basic logic is like:

Load

[Main Date]

From <> Where [Main Date]>=Today()-100;

Now you have to take care of the format of the data so that comparison under where clause could be made to filter.

israrkhan — Wed, 13 Aug 2014 10:36:28 GMT

You can try some thing like..

load * ,

Date(MinDate) as MinDate

from yourSource

where Date(MinDate) >= Date(Today()) -100

or..

load * ,

Date(MinDate) as MinDate

from yourSource

where num(MinDate) >= num(Today()) -100

Wed, 13 Aug 2014 10:39:50 GMT

Is it possible to use 'If condition' between the table ...if yes please tell me the syntax..

tresB — Wed, 13 Aug 2014 10:43:01 GMT

Rahul Yadav wrote:

Is it possible to use 'If condition' between the table ...if yes please tell me the syntax..

I could not understand your 'between the table'. Could you explain a bit more?

Wed, 13 Aug 2014 10:48:59 GMT

Means

Load *,

If(maindate=Today() and Today() - '100',maindate,Null()) as maindate,

From Sourcedata;

can I use this..?

tresB — Wed, 13 Aug 2014 10:56:22 GMT

Yes, may be more accurately like:

Load *,

If(maindate>=Today() - 100,maindate,Null()) as maindate

From Sourcedata;