topic Re: Making a selection from a selection... in QlikView https://community.qlik.com/t5/QlikView/Making-a-selection-from-a-selection/m-p/363055#M134982 <HTML><HEAD></HEAD><BODY><P>You can try something like this.</P><P></P><P>I am using two variables:</P><P></P><P>vStartDate</P><P>vEndDate</P><P></P><P>Then I'm using those two variables in my set analysis expression:</P><P></P><P>Sum ( {$&lt; [Creation Date]={"&gt;=$(vStartDate)&lt;=$(vEndDate)"} &gt;} Value)</P><P></P><P>See attached.</P></BODY></HTML> Tue, 22 May 2012 18:30:52 GMT oscar_ortiz 2012-05-22T18:30:52Z Making a selection from a selection... https://community.qlik.com/t5/QlikView/Making-a-selection-from-a-selection/m-p/363054#M134981 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>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 !</P><P></P><P>I have a calendar table that gives all the dates between the min &amp; max reporting dates in my data.</P><P></P><P>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.</P><P></P><P>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.</P><P></P><P>Is this easy or even possible?</P><P></P><P>Many thanks,</P><P>Phil</P></BODY></HTML> Tue, 22 May 2012 10:48:12 GMT https://community.qlik.com/t5/QlikView/Making-a-selection-from-a-selection/m-p/363054#M134981 2012-05-22T10:48:12Z Re: Making a selection from a selection... https://community.qlik.com/t5/QlikView/Making-a-selection-from-a-selection/m-p/363055#M134982 <HTML><HEAD></HEAD><BODY><P>You can try something like this.</P><P></P><P>I am using two variables:</P><P></P><P>vStartDate</P><P>vEndDate</P><P></P><P>Then I'm using those two variables in my set analysis expression:</P><P></P><P>Sum ( {$&lt; [Creation Date]={"&gt;=$(vStartDate)&lt;=$(vEndDate)"} &gt;} Value)</P><P></P><P>See attached.</P></BODY></HTML> Tue, 22 May 2012 18:30:52 GMT https://community.qlik.com/t5/QlikView/Making-a-selection-from-a-selection/m-p/363055#M134982 oscar_ortiz 2012-05-22T18:30:52Z