topic Re: How to filter a line graph with lines of different data granularity? in App Development https://community.qlik.com/t5/App-Development/How-to-filter-a-line-graph-with-lines-of-different-data/m-p/120101#M8369 <HTML><HEAD></HEAD><BODY><P>Dear Aar Kay,</P><P></P><P>Of course!</P><P>Your are completely right. I overlooked this.</P><P>Thank you very much for your support.</P><P></P><P>Best regards,</P><P>Pim</P></BODY></HTML> Thu, 09 Aug 2018 07:30:16 GMT Anonymous 2018-08-09T07:30:16Z How to filter a line graph with lines of different data granularity? https://community.qlik.com/t5/App-Development/How-to-filter-a-line-graph-with-lines-of-different-data/m-p/120099#M8367 <HTML><HEAD></HEAD><BODY><P>Dear all,</P><P></P><P>How can I filter the red line with high granularity without loosing (part of) the blue line with data of low granularity?</P><P><IMG alt="TG01.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/210252_TG01.PNG" style="height: 185px; width: 620px;" /></P><P>When I filter the red line on basis of an associated field then the middle and right data points of the blue line are lost. Only the left data point remains.</P><P><IMG alt="TG02.PNG" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/210253_TG02.PNG" style="height: 180px; width: 620px;" /></P><P><SPAN style="font-size: 10pt;">The blue data points disappear since there isn't any red line data (with the filtered value of the associated field) on the dates that the blue line data is available.</SPAN></P><P>I have used a SET condition that should screen off the blue line from selections of the associated field (Opp_Prob) of the red line:</P><P>Sum({&lt;Opp_Prob=&gt;}OI) but appearently it doesn't work.</P><P></P><P>See the attached app and data source excel file.</P></BODY></HTML> Wed, 08 Aug 2018 14:38:07 GMT https://community.qlik.com/t5/App-Development/How-to-filter-a-line-graph-with-lines-of-different-data/m-p/120099#M8367 Anonymous 2018-08-08T14:38:07Z Re: How to filter a line graph with lines of different data granularity? https://community.qlik.com/t5/App-Development/How-to-filter-a-line-graph-with-lines-of-different-data/m-p/120100#M8368 <HTML><HEAD></HEAD><BODY><P><STRONG>OI = Rangesum(above(Sum({&lt;Opp_Prob=&gt;}OI),0,RowNo()))/Min(<SPAN style="color: #ff0000;">{&lt;Opp_Prob&gt;}</SPAN>Display)</STRONG></P></BODY></HTML> Wed, 08 Aug 2018 15:12:19 GMT https://community.qlik.com/t5/App-Development/How-to-filter-a-line-graph-with-lines-of-different-data/m-p/120100#M8368 aarkay29 2018-08-08T15:12:19Z Re: How to filter a line graph with lines of different data granularity? https://community.qlik.com/t5/App-Development/How-to-filter-a-line-graph-with-lines-of-different-data/m-p/120101#M8369 <HTML><HEAD></HEAD><BODY><P>Dear Aar Kay,</P><P></P><P>Of course!</P><P>Your are completely right. I overlooked this.</P><P>Thank you very much for your support.</P><P></P><P>Best regards,</P><P>Pim</P></BODY></HTML> Thu, 09 Aug 2018 07:30:16 GMT https://community.qlik.com/t5/App-Development/How-to-filter-a-line-graph-with-lines-of-different-data/m-p/120101#M8369 Anonymous 2018-08-09T07:30:16Z