topic Advanced filtering, element wise comparison on set in App Development https://community.qlik.com/t5/App-Development/Advanced-filtering-element-wise-comparison-on-set/m-p/1384450#M31663 <HTML><HEAD></HEAD><BODY><P>Hi everyone, I've been playing around with Qlik sense for a few days now and I'm trying to implement the following:</P><P></P><P><IMG alt="table example.PNG" class="jive-image image-1" height="134" src="/legacyfs/online/178385_table example.PNG" style="height: 134px; width: 199.804px;" width="200" /></P><P>It's a simple schedule where actions have a location, a begin date and an end date.</P><P></P><P>A location can only have one action scheduled at a time, so the goal is to color the background of conflicting situations.</P><P></P><P>One added difficutly, I must be able to select the date range in the application, so it should be solved dynamically on the set and not in the load stage (or not completely at least).</P><P></P><P>I've tried many approaches but never got it quite right so I'm open to all solutions.</P></BODY></HTML> Tue, 03 Oct 2017 08:49:38 GMT 2017-10-03T08:49:38Z Advanced filtering, element wise comparison on set https://community.qlik.com/t5/App-Development/Advanced-filtering-element-wise-comparison-on-set/m-p/1384450#M31663 <HTML><HEAD></HEAD><BODY><P>Hi everyone, I've been playing around with Qlik sense for a few days now and I'm trying to implement the following:</P><P></P><P><IMG alt="table example.PNG" class="jive-image image-1" height="134" src="/legacyfs/online/178385_table example.PNG" style="height: 134px; width: 199.804px;" width="200" /></P><P>It's a simple schedule where actions have a location, a begin date and an end date.</P><P></P><P>A location can only have one action scheduled at a time, so the goal is to color the background of conflicting situations.</P><P></P><P>One added difficutly, I must be able to select the date range in the application, so it should be solved dynamically on the set and not in the load stage (or not completely at least).</P><P></P><P>I've tried many approaches but never got it quite right so I'm open to all solutions.</P></BODY></HTML> Tue, 03 Oct 2017 08:49:38 GMT https://community.qlik.com/t5/App-Development/Advanced-filtering-element-wise-comparison-on-set/m-p/1384450#M31663 2017-10-03T08:49:38Z