topic Re: Re: date range using slider object in QlikView

date range using slider object

Wed, 18 Sep 2013 20:34:25 GMT

Hi,

I want to be able to select date ranges using slider objects.

I have created 3 slider objects with following expressions:

=SUBFIELD(DATE(SubField(RUN_DATE,' ',1),'DD/MMM/YYYY'),'/',1)-day

=SUBFIELD(DATE(SubField(RUN_DATE,' ',1),'DD/MMM/YYYY'),'/',2)-month

=SUBFIELD(DATE(SubField(RUN_DATE,' ',1),'DD/MMM/YYYY'),'/',3)-year.

the problem is that if I were to select some value for day and then select month, the selection in day is lost and so on.

is there any other way for the user to be able to select date ranges?

Thanks,

Anju

Re: date range using slider object

MayilVahanan — Wed, 18 Sep 2013 20:41:47 GMT

Bring all the fields (day,month, year) from script itself, then use in slider object.

Hope that helps

Re: date range using slider object

srchilukoori — Wed, 18 Sep 2013 20:46:54 GMT

What is the format of RUN_DATE? could you please explain the task that you are trying to accomplish in more detail.

Re: date range using slider object

Thu, 19 Sep 2013 04:38:48 GMT

Hi Ramasamy,

I used this piece of code ....

But, on reload, it says field not found for run_date_format.

MasterCalendar:

select run_date as run_date_format from tt_sdp_rpx_summary;

master:

load
//subfield(date(subfield(run_date_format,' ',1),'DD/MM/YYYY'),'/',1) as day_tt,
//subfield(date(subfield(run_date_format,' ',1),'DD/MMM/YYYY'),'/',2) as month_tt,
//subfield(date(subfield(run_date_format,' ',1),'DD/MM/YYYY'),'/',3) as year_tt
day(run_date_format) as day,
monthname(run_date_format) as month_tt,
year(run_date_format) as year_tt
Resident MasterCalendar;

drop table MasterCalendar;

Re: date range using slider object

tresB — Thu, 19 Sep 2013 04:44:32 GMT

try this:

select run_date as run_date_format from tt_sdp_rpx_summary;

master:

load
day(run_date) as day,
monthname(run_date) as month_tt,
year(run_date) as year_tt
Resident MasterCalendar;

drop table MasterCalendar;

Re: date range using slider object

Thu, 19 Sep 2013 04:47:41 GMT

Hi,

One example of run_date is 8/16/2013 12:00:00 AM,

i want to extract dd/mm/yyyy from this date and give a from date - to date selection option in the report.

Thanks,

Anju

Re: date range using slider object

Thu, 19 Sep 2013 04:51:07 GMT

Hi,

I tried it... but it gives the same error ..... field not found<run_date>

Re: Re: date range using slider object

Thu, 19 Sep 2013 12:18:27 GMT

Hi,

PFA the report with run_date loaded from db.

I was not able to attach the report in the branched discussion.

Thanks,

Anju

Re: Re: Re: date range using slider object

tresB — Thu, 19 Sep 2013 12:27:47 GMT

Run a reload in attached file and let know the result.

Re: Re: date range using slider object

srchilukoori — Thu, 19 Sep 2013 12:34:06 GMT

Check the date expression from the attached app.

Calendar object gives an elegant way to choose a date rather than slider object.