topic Re: Date Help -2 in QlikView

Date Help -2

Anonymous — Mon, 11 Apr 2016 15:55:35 GMT

Hi All,

I have created an variable called "vDate" for "My_Date" field and wonder if it's possible to select multiple dates via an InputBox and Date Slider? For the Slider, i couldn't even populate the date data via variable selected. Attached sample QVW.

Any Input greately appreciated!

Thanks,

Frank

Re: Date Help -2

sunny_talwar — Mon, 11 Apr 2016 15:58:04 GMT

You want to select multiple dates from single variable? I doubt that is possible, but you can def. select a date range using two variables.

Selecting Arbitrary Date Ranges

Re: Date Help -2

sunny_talwar — Mon, 11 Apr 2016 16:00:55 GMT

Try the attached (Using variable triggers)

Re: Date Help -2

settu_periasamy — Mon, 11 Apr 2016 16:18:11 GMT

May be try with using Multibox Object (using ctrl key to select multiple date)

Re: Date Help -2

Anonymous — Mon, 11 Apr 2016 20:44:31 GMT

Sunny,

Hope things are well!

I'm still testing this 2 variables and also tried to add a "IF SUM" formula but doesn't works. Let me know if you can help.

=if(My_Date= '>=' & '12/31/2015' & '<=' & '05/03/2016' , sum([Amount])+1000, sum([Amount]))

Re: Date Help -2

sunny_talwar — Mon, 11 Apr 2016 20:46:32 GMT

You want to apply these filters to a specific chart or the whole application?

Re: Date Help -2

Anonymous — Mon, 11 Apr 2016 20:51:10 GMT

To a Chart.

Re: Date Help -2

sunny_talwar — Mon, 11 Apr 2016 20:56:15 GMT

So between the two selected dates you want Sum(Amount) + 1000 and for every other date you want Sum(Amount)?

Re: Date Help -2

sunny_talwar — Mon, 11 Apr 2016 20:57:21 GMT

Try thus:

RangeSum(

Sum({<My_Date = {"$(='>='& Date(vDateStart) & '<=' & Date(vDateEnd))"}>} Amount) + 1000,

Sum({<My_Date -= {"$(='>='& Date(vDateStart) & '<=' & Date(vDateEnd))"}>} Amount))

Re: Date Help -2

Anonymous — Mon, 11 Apr 2016 21:10:21 GMT

the excluded part didn't work..All other date's have the 1000 added as well.

Sum({<My_Date-={"$(='>='& Date(vDateStart) & '<=' & Date(vDateEnd))"}>} Amount)

Re: Date Help -2

sunny_talwar — Mon, 11 Apr 2016 22:11:01 GMT

Try this:

RangeSum(

Sum({<My_Date = {"$(='>='& Date(vDateStart) & '<=' & Date(vDateEnd))"}>} Amount) + Avg({<My_Date = {"$(='>='& Date(vDateStart) & '<=' & Date(vDateEnd))"}>}1000),

Sum({<My_Date -= {"$(='>='& Date(vDateStart) & '<=' & Date(vDateEnd))"}>} Amount))

Re: Date Help -2

Anonymous — Mon, 11 Apr 2016 22:28:44 GMT

Thanks Sunny. Not sure how "AVG()" plays a role in this RangSum..

Re: Date Help -2

sunny_talwar — Mon, 11 Apr 2016 22:35:08 GMT

Just so we can use the set analysis to add 1000 to just the selected range. You can replace it with Only()