topic Re: Re: Filtering Pivot Tables in QlikView https://community.qlik.com/t5/QlikView/Filtering-Pivot-Tables/m-p/474814#M177295 <HTML><HEAD></HEAD><BODY><P>See the attached for an example.</P></BODY></HTML> Wed, 11 Dec 2013 20:02:40 GMT Nicole-Smith 2013-12-11T20:02:40Z Filtering Pivot Tables https://community.qlik.com/t5/QlikView/Filtering-Pivot-Tables/m-p/474811#M177292 <HTML><HEAD></HEAD><BODY><P>I'm trying to apply a date range filter to a pivot table.&nbsp; I created a calculation condition which says "dateOfService&lt;=EndDate and dateOfService&gt;=StartDate".&nbsp; This condition is not having the desired effect. Can you please advise as to what I would need to do to get this type of condition.</P><P></P><P>StartDate and EndDate are input boxes.</P></BODY></HTML> Wed, 11 Dec 2013 18:08:54 GMT https://community.qlik.com/t5/QlikView/Filtering-Pivot-Tables/m-p/474811#M177292 2013-12-11T18:08:54Z Re: Filtering Pivot Tables https://community.qlik.com/t5/QlikView/Filtering-Pivot-Tables/m-p/474812#M177293 <HTML><HEAD></HEAD><BODY><P>You don't want it in the calculation condition, you want it in set analysis in the expression.&nbsp; For example:</P><P></P><P>sum({&lt;dateofService={'&gt;=$(StartDate)&lt;=$(EndDate)'}&gt;}Sales)</P></BODY></HTML> Wed, 11 Dec 2013 19:18:48 GMT https://community.qlik.com/t5/QlikView/Filtering-Pivot-Tables/m-p/474812#M177293 Nicole-Smith 2013-12-11T19:18:48Z Re: Filtering Pivot Tables https://community.qlik.com/t5/QlikView/Filtering-Pivot-Tables/m-p/474813#M177294 <HTML><HEAD></HEAD><BODY><P>Can you give me a small walkthrough as to how to set that up?&nbsp; I'm still very new to Qlikview.</P></BODY></HTML> Wed, 11 Dec 2013 19:57:58 GMT https://community.qlik.com/t5/QlikView/Filtering-Pivot-Tables/m-p/474813#M177294 2013-12-11T19:57:58Z Re: Re: Filtering Pivot Tables https://community.qlik.com/t5/QlikView/Filtering-Pivot-Tables/m-p/474814#M177295 <HTML><HEAD></HEAD><BODY><P>See the attached for an example.</P></BODY></HTML> Wed, 11 Dec 2013 20:02:40 GMT https://community.qlik.com/t5/QlikView/Filtering-Pivot-Tables/m-p/474814#M177295 Nicole-Smith 2013-12-11T20:02:40Z