topic Re: Date range slider does not show appropriate dates in QlikView

Date range slider does not show appropriate dates

Thu, 28 Jul 2016 11:49:49 GMT

Dear all,

I work on the attached file which should basically be a slider which allows you to select dates. And then only the relevant data should pop up in the bar chart. It all seems to work however the two selection sliders only allow me to

Any thoughts on what goes wrong here>?

Re: Date range slider does not show appropriate dates

Anil_Babu_Samineni — Thu, 28 Jul 2016 12:11:53 GMT

Marc, Can you please let me know

LOAD * INLINE [

Country, Value, Salesdata

USA, 12, 2013-01-04

USA, 14, 2013-02-05

USA, 14, 2013-02-06

USA, 14, 2013-02-07

];

let vFromDate = Floor(Date#('2013-01-01', 'YYYY-MM-DD'));

let vToDate = Floor(Date#('2013-06-30', 'YYYY-MM-DD'));

In that Variables you used the 01-01-2013 and 30-06-2013

But, In your data you don't have Data. How do you Achieve that

Selecting Arbitrary Date Ranges - YouTube

Re: Date range slider does not show appropriate dates

r3iuk — Thu, 28 Jul 2016 12:26:08 GMT

2 Options depending on what kind of date select control you want to use.

1. If as in your example you want 2 calendar controls, then in each control set the following:

Min Value: =min(Salesdata)

Max Value: =max(Salesdata)

2. If you want a single Slider control then set its field to Salesdata, and in Multi Value mode. Then in your chart, the expression just needs to be Sum(Value)

Re: Date range slider does not show appropriate dates

trdandamudi — Thu, 28 Jul 2016 12:36:23 GMT

Please see the attached file and modify according to your needs. In this app based on your requirement you can select the dates from 2013-01-01 to 2013-06-30. Hope this helps..