topic how to use set analysis for creating a date range in QlikView

how to use set analysis for creating a date range

Mon, 22 Aug 2011 18:04:51 GMT

I want to creat a flag with a date range(3/10/2011, 3/17/2011) using set analysis, Please help me

how to use set analysis for creating a date range

Mon, 22 Aug 2011 19:23:53 GMT

Hi Pramod,

That you have to do in the backend.

For example say the Date field in your script is called Calendar,

// Back End Situation

Temp:

Load *,

if(Date(Calendar)>='03/10/2011' and Date(Calendar)<='03/17/2011', 'Flag', 'No Flag') as DATE_FLAG

;

and then reload you will get a flag field in your data model, which you can utilize.

Now, if those selected dates are to be variable, then you will need to define more what exactly is your situation.

Also, I haven't have knowledge if Set Analysis works in Backend.

// In front end i am not ready yet to answer this question.

Because as per my knowledge, set analysis does aggregation function, so how can it set flags for a date range is what I would also be interested in learning.

Hope this helps,

Bikash Debnath

how to use set analysis for creating a date range

Mon, 22 Aug 2011 19:54:57 GMT

tq Bikash,

instead of if, I need to use set analysis in the front end for creating a column, if the date is in range then we need to give value ' 1' else 'o'

how to use set analysis for creating a date range

Mon, 22 Aug 2011 20:00:31 GMT

It can be very easily done with if...else statement, as you will need to compare all the records in your database.

how to use set analysis for creating a date range

Mon, 22 Aug 2011 20:13:14 GMT

yea it can be done with if condition but I have some more things to add to that expression, so I need to use set analysis

how to use set analysis for creating a date range

Mon, 22 Aug 2011 20:27:16 GMT

Hi Pramod,

if you could specify what more conditions do you need to add, then we can think of something.

But creating a flag is a RAM consuming process, so it will be better if you do it in Backend. But backend will support if...else statement.

Regards,

Bikash