topic Re: Use drilled-down dimension filter on different field in App Development https://community.qlik.com/t5/App-Development/Use-drilled-down-dimension-filter-on-different-field/m-p/1136182#M20045 <HTML><HEAD></HEAD><BODY><P>It works. Thank you</P></BODY></HTML> Fri, 19 Aug 2016 12:04:16 GMT Anonymous 2016-08-19T12:04:16Z Use drilled-down dimension filter on different field https://community.qlik.com/t5/App-Development/Use-drilled-down-dimension-filter-on-different-field/m-p/1136178#M20041 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>I have a drill-down dimension setup as this:</P><UL><LI>CalendarYear</LI><LI><SPAN style="font-size: 13.3333px;">CalendarQuarter</SPAN></LI><LI><SPAN style="font-size: 13.3333px;">CalendarMonth</SPAN></LI><LI><SPAN style="font-size: 13.3333px;">CalendarWeek</SPAN></LI><LI><SPAN style="font-size: 13.3333px;">CalendarDate</SPAN></LI></UL><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">However, I have a chart that needs to use a different dimension to all other charts: instead of CalendarDate, I need it to use ClosedDate. The issue is that an item can have both a CalendarDate and a ClosedDate and they would be different.</SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">So I have started by making the measure ignore all filters by using {1} in the SetAnalysis. Works fine. but what i would like to do is: instead of having it ignore all filters, have it show me where ClosedDate is equal to the range of CalendarDate that was selected in the filter. As stated above, the ClosedDate and CalendarDate may be different and I would like it to be based solely on ClosedDate. let's consider the sample date below:</SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">Table:</SPAN></P><P></P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Item</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>CalendarDate</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>ClosedDate</STRONG></TH></TR><TR><TD style="padding: 2px;">ID1</TD><TD style="padding: 2px;">31st Dec 2015</TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">1st Jan 2016</SPAN></TD></TR><TR><TD style="padding: 2px;">ID2</TD><TD style="padding: 2px;">1st Jan 2016</TD><TD style="padding: 2px;">5th Jan 2016</TD></TR><TR><TD style="padding: 2px;">ID3</TD><TD style="padding: 2px;">2nd Jan 2016</TD><TD style="padding: 2px;">2nd Jan 2016</TD></TR></TBODY></TABLE><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">At the minute, if my filter (used for all other charts in the app) is for the 1st of Jan 2016 as CalendarDate, it will show me the item ID2.</SPAN></P><P><SPAN style="font-size: 13.3333px;">If I have the SetAnalysis at {1}, it shows me ID1, ID2 and ID3 (obviously) but I would like to end up with it showing only ID1 which has the only ClosedDate of 1st Jan 2016.</SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">Anything possible?<BR /></SPAN></P></BODY></HTML> Thu, 18 Aug 2016 20:32:25 GMT https://community.qlik.com/t5/App-Development/Use-drilled-down-dimension-filter-on-different-field/m-p/1136178#M20041 Anonymous 2016-08-18T20:32:25Z Re: Use drilled-down dimension filter on different field https://community.qlik.com/t5/App-Development/Use-drilled-down-dimension-filter-on-different-field/m-p/1136179#M20042 <HTML><HEAD></HEAD><BODY><P>May be like this:</P><P></P><P><STRONG>{1&lt;ClosedDate = p(CalendarDate)&gt;}</STRONG></P></BODY></HTML> Thu, 18 Aug 2016 22:14:13 GMT https://community.qlik.com/t5/App-Development/Use-drilled-down-dimension-filter-on-different-field/m-p/1136179#M20042 sunny_talwar 2016-08-18T22:14:13Z Re: Use drilled-down dimension filter on different field https://community.qlik.com/t5/App-Development/Use-drilled-down-dimension-filter-on-different-field/m-p/1136180#M20043 <HTML><HEAD></HEAD><BODY><P class="">I will try it on the morning. Thanks. Out of curiosity, what does the p do?</P></BODY></HTML> Thu, 18 Aug 2016 22:41:25 GMT https://community.qlik.com/t5/App-Development/Use-drilled-down-dimension-filter-on-different-field/m-p/1136180#M20043 Anonymous 2016-08-18T22:41:25Z Re: Use drilled-down dimension filter on different field https://community.qlik.com/t5/App-Development/Use-drilled-down-dimension-filter-on-different-field/m-p/1136181#M20044 <HTML><HEAD></HEAD><BODY><P>Will show all possible value from CalendarDate within your ClosedDate and will exclude everything else from ClosedDate</P></BODY></HTML> Fri, 19 Aug 2016 08:32:21 GMT https://community.qlik.com/t5/App-Development/Use-drilled-down-dimension-filter-on-different-field/m-p/1136181#M20044 sunny_talwar 2016-08-19T08:32:21Z Re: Use drilled-down dimension filter on different field https://community.qlik.com/t5/App-Development/Use-drilled-down-dimension-filter-on-different-field/m-p/1136182#M20045 <HTML><HEAD></HEAD><BODY><P>It works. Thank you</P></BODY></HTML> Fri, 19 Aug 2016 12:04:16 GMT https://community.qlik.com/t5/App-Development/Use-drilled-down-dimension-filter-on-different-field/m-p/1136182#M20045 Anonymous 2016-08-19T12:04:16Z