topic Re: Display dates in slider object in QlikView

Display dates in slider object

Anonymous — Tue, 24 Jan 2012 11:48:52 GMT

Hi,

I am new to QlikView; I have a slider object, mapped to a field that represents 2 year's worth of dates to which data is assigned - therefore, I cannot create a slider object that will show all the dates, as it would be way too long for the screen. The slider object is multi-value, as the user needs to select a date range, and it has 1 minor unit for each of the 12 major units. The problem I have is that you cannot accurately determine the "start" date before selecting it to begin the date range selection, because the date value is not displayed - for example, if one of the major units is '3-22-2011', and I want to start a date range from "3-1-2011', it is a guess to determine where to click between the minor and major unit, as the date value is not displayed until you click within the slider - if it's wrong, you have to clear the selection and try again. A calendar object is not suitable because the user needs to be able to select a date range across multiple months.

Is there a way to display the date value that the mouse is hovering over within the slider, before you click within the slider object?

Thank you,

Re: Display dates in slider object

Tue, 24 Jan 2012 12:23:42 GMT

Hi V B,

Instead of Slider, you can try another way for selecting the date range.

it looks like below image in a easy way i.e; through listbox.

You can split the date field into three parts i.e; Day, Month , Year

Day = Day(DateField)

Year = Year(DateField)

Month = Month(DateField)

I don't know exactly whether it is possible to display the date value that the mouse is hovering over within the slider.

Try this it may be helpful to you.

Regards

Ravi.

Re: Display dates in slider object

stephencredmond — Tue, 24 Jan 2012 12:28:22 GMT

Hi VB,

If you need the users to select Start/End, then I would use two calendar controls and then a button to apply the selection.

See attached example.

Stephen

Re: Display dates in slider object

greg-anderson — Mon, 06 Jan 2014 19:50:12 GMT

To add to what others have said, I avoid slider bars in any situation where another control (or pair of controls) will suffice. In the case of a date range, I would definitely lean towards calendar controls or even validated text fields.

Slider bars sound good in concept but often lead to user confusion and frustration, in my experience.

BTW- this is not a QlikView complaint. This a graphical design preference.

Re: Display dates in slider object

Colin-Albert — Mon, 06 Jan 2014 22:36:15 GMT

Hi VB

Attached is a link to an example app showing how you can switch between either selecting dates by year & month or by selecting a start & end date.

Hope this helps.

Colin

Date Selections - By Period & Range

Re: Display dates in slider object

Mon, 07 Apr 2014 09:45:31 GMT

Hi Ravi,

Can you please elaborate on how to achieve this step-by-step? I am new to Qlikview and do not know how to configure a control to display in this way.

Thanks

Sheldon

Re: Re: Display dates in slider object

Mon, 07 Apr 2014 10:33:30 GMT

Ex:

Temp:

Load

DateField,

Year(DateField) as Year,

Month(DateField) as Month,

Day(DateField) as Day

From SourceData;

Now You can provide Year,Month and Day fields for calender selection in your dashboard.

Re: Re: Display dates in slider object

Mon, 07 Apr 2014 11:06:03 GMT

Thanks Ravi,

I am using SQL in my case. Can you provide and example using SQL?

I am also not sure how to create the ListBox as you have it in your screenshot.

Regards,

Sheldon

Re: Re: Re: Display dates in slider object

Mon, 07 Apr 2014 11:15:47 GMT

Do you know how to connect to sql and fetch data from qlikview ?

Re: Re: Display dates in slider object

Mon, 07 Apr 2014 11:24:55 GMT

Yes I do, I'm just not sure on the next steps to get the ListBox to display the data as checkboxes like you have.

I suppose I must use the following type of script for SQL?

SQL SELECT ldDate, Year(ldDate) As Year, Month(ldDate) As Month FROM Labour_Details

Re: Re: Re: Display dates in slider object

Mon, 07 Apr 2014 11:45:33 GMT

Find the sample atatchment

Re: Re: Display dates in slider object

Mon, 07 Apr 2014 12:00:12 GMT

Thank you Ravi,

I have the data displaying as desired, thank you. However, the List boxes are listing text data and not checkboxes. How do I get the checkboxes like you have in your screenshot?

Thanks

Sheldon

Re: Display dates in slider object

Mon, 07 Apr 2014 12:20:35 GMT

Have you seen my attachment Sample.qvw?

Re: Re: Display dates in slider object

Mon, 07 Apr 2014 12:44:18 GMT

Yes I have, thank you.

However, I do not see what setting to use to make them display as a checkbox as you have it in your image.

Re: Re: Re: Display dates in slider object

Tue, 08 Apr 2014 03:42:37 GMT

Please follow like this in the image.

Rightclick on each of the listbox and change its presentation and you will get the same look and feel.

Re: Re: Re: Display dates in slider object

Tue, 08 Apr 2014 15:55:04 GMT

Great, thank you very much!