Making a selection from a selection...

[#1]

Hi All,

I've had a great idea for some functionality on a Qlik app I'm working on, trouble is I have to present it tomorrow and have no idea how to implement it !

I have a calendar table that gives all the dates between the min & max reporting dates in my data.

The users can select a specific year, month or day to view data for, what I'd really like to do is allow the user to select a start and end date.

I can create a checkbox, if the user clicks on this I can unhide a table, but then on this table I'd want the user to be able to select a start and end date from my calendar object, then when the user has updated the dates I want the application to make a selection on the calendar date field based on the two values selected by the user.

Is this easy or even possible?

Many thanks,

Phil

[oscar_ortiz]

You can try something like this.

I am using two variables:

vStartDate

vEndDate

Then I'm using those two variables in my set analysis expression:

Sum ( {$< [Creation Date]={">=$(vStartDate)<=$(vEndDate)"} >} Value)

See attached.