topic Re: date range using slider object in QlikView

Re: date range using slider object

tresB — Thu, 19 Sep 2013 05:42:17 GMT

Have you tried only loading the run_date from DB? Check if it is actually being fetched from the DB. And try another load with changed sequence like:

Master:

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

select run_date from tt_sdp_rpx_summary;

Re: date range using slider object

Thu, 19 Sep 2013 06:51:59 GMT

when I give only the select statement , it feteches data from db.

but, when I give the load statement , it gives the error => field not found for run_date.

I tried your load statement. It gives the same error.

Re: date range using slider object

Thu, 19 Sep 2013 06:53:43 GMT

is there any other way to select date ranges?

Re: date range using slider object

tresB — Thu, 19 Sep 2013 07:16:42 GMT

See, now it looks like this discussion has been initiated by me (which is certainly not). This is possibly because Anju Gopinath has deleted the first post. It would be nice if community people please have a note of this issue.

Coming back to question, I would request to share a sample app with described expected result.

Re: date range using slider object

Thu, 19 Sep 2013 07:28:48 GMT

I did not delete any post. I just used branch feature under the discussion.This is the first time I have used it and apparently, this is how it appears...

Re: date range using slider object

Thu, 19 Sep 2013 07:36:40 GMT

how do I insert a qvw?

Re: Re: date range using slider object

tresB — Thu, 19 Sep 2013 11:41:40 GMT

Click on 'Reply'->Top right corner of the editor 'Use advanced editor' -> Bottom right corner 'Attach'