topic Qlikview - How to create a line chart with selected item (Dimension: Product, selected by filters) and the other top 5 (Dimension: Product), all in the same chart? in QlikView https://community.qlik.com/t5/QlikView/Qlikview-How-to-create-a-line-chart-with-selected-item-Dimension/m-p/1317872#M408874 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 13.3333px;">Qlikview - How to create a line chart with selected item (Dimension: Product, selected by filters) and the other top 5 (Dimension: Product), all in the same chart?</SPAN></P></BODY></HTML> Mon, 19 Jun 2017 19:03:44 GMT 2017-06-19T19:03:44Z Qlikview - How to create a line chart with selected item (Dimension: Product, selected by filters) and the other top 5 (Dimension: Product), all in the same chart? https://community.qlik.com/t5/QlikView/Qlikview-How-to-create-a-line-chart-with-selected-item-Dimension/m-p/1317872#M408874 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 13.3333px;">Qlikview - How to create a line chart with selected item (Dimension: Product, selected by filters) and the other top 5 (Dimension: Product), all in the same chart?</SPAN></P></BODY></HTML> Mon, 19 Jun 2017 19:03:44 GMT https://community.qlik.com/t5/QlikView/Qlikview-How-to-create-a-line-chart-with-selected-item-Dimension/m-p/1317872#M408874 2017-06-19T19:03:44Z Re: Qlikview - How to create a line chart with selected item (Dimension: Product, selected by filters) and the other top 5 (Dimension: Product), all in the same chart? https://community.qlik.com/t5/QlikView/Qlikview-How-to-create-a-line-chart-with-selected-item-Dimension/m-p/1317873#M408875 <HTML><HEAD></HEAD><BODY><P><SPAN style="text-decoration: line-through;">you could use a synthetic dimension</SPAN></P><P></P><P><SPAN style="text-decoration: line-through;">for example valuelist('Selection','Top5')</SPAN></P><P></P><P><SPAN style="text-decoration: line-through;">and then an expression something like that</SPAN></P><P></P><P><SPAN style="text-decoration: line-through;">if(valuelist('Selection','Top5')='Selection',</SPAN></P><P><SPAN style="text-decoration: line-through;">&nbsp;&nbsp;&nbsp;&nbsp; //Selection</SPAN></P><P><SPAN style="text-decoration: line-through;">&nbsp;&nbsp;&nbsp;&nbsp; sum(YourFIELD),</SPAN></P><P><SPAN style="text-decoration: line-through;">&nbsp;&nbsp;&nbsp;&nbsp; //top 5 ingnored selection</SPAN></P><P><SPAN style="text-decoration: line-through;">&nbsp;&nbsp;&nbsp;&nbsp; sum({1&lt;&nbsp; YourFIELD={"=Rank(sum(YourField),4)&lt;=5"}&nbsp; &gt; } YourFIELD)</SPAN></P><P><SPAN style="text-decoration: line-through;">)</SPAN></P><P><SPAN style="text-decoration: line-through;"><BR /></SPAN></P><P>I think I was wrong, you can just use 2 separate expression like that</P><P>&nbsp;&nbsp;&nbsp;&nbsp; sum(YourFIELD)</P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp; sum({1&lt;&nbsp; YourFIELD={"=Rank(sum(YourField),4)&lt;=5"}&nbsp; &gt; } YourFIELD)</P></BODY></HTML> Mon, 19 Jun 2017 19:10:11 GMT https://community.qlik.com/t5/QlikView/Qlikview-How-to-create-a-line-chart-with-selected-item-Dimension/m-p/1317873#M408875 Anonymous 2017-06-19T19:10:11Z Re: Qlikview - How to create a line chart with selected item (Dimension: Product, selected by filters) and the other top 5 (Dimension: Product), all in the same chart? https://community.qlik.com/t5/QlikView/Qlikview-How-to-create-a-line-chart-with-selected-item-Dimension/m-p/1317874#M408876 <HTML><HEAD></HEAD><BODY><P>Hello Robin, Thanks! <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">Would be possible Top 5 - item by item together with the item selected? (6 lines)</SPAN></P></BODY></HTML> Mon, 19 Jun 2017 19:21:34 GMT https://community.qlik.com/t5/QlikView/Qlikview-How-to-create-a-line-chart-with-selected-item-Dimension/m-p/1317874#M408876 2017-06-19T19:21:34Z Re: Qlikview - How to create a line chart with selected item (Dimension: Product, selected by filters) and the other top 5 (Dimension: Product), all in the same chart? https://community.qlik.com/t5/QlikView/Qlikview-How-to-create-a-line-chart-with-selected-item-Dimension/m-p/1317875#M408877 <HTML><HEAD></HEAD><BODY><P>if(</P><P>&nbsp;&nbsp;&nbsp;&nbsp; rank(total sum(YourField),4)&lt;=5,</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; sum(YourField)</P><P>)</P><P></P><P>----------------</P><P>total is optional</P></BODY></HTML> Tue, 20 Jun 2017 16:54:45 GMT https://community.qlik.com/t5/QlikView/Qlikview-How-to-create-a-line-chart-with-selected-item-Dimension/m-p/1317875#M408877 Anonymous 2017-06-20T16:54:45Z