Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

Date Help -2

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

1 Solution

Accepted Solutions
Highlighted

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))

View solution in original post

12 Replies
Highlighted

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

Highlighted

Try the attached (Using variable triggers)

Highlighted

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

Highlighted
Creator
Creator

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]))

Highlighted

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

Highlighted
Creator
Creator

To a Chart.

Highlighted

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

Highlighted

Try thus:

RangeSum(

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

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

Highlighted
Creator
Creator

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

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