topic Grouping Dimension Values for a Funnel Diagramm in QlikView https://community.qlik.com/t5/QlikView/Grouping-Dimension-Values-for-a-Funnel-Diagramm/m-p/971320#M526945 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I want to create a funnel diagramm to show how deep visitors are digging into the content of the page. The data looks somehow like this:</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">Pages</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Hits</TH></TR><TR><TD style="padding: 2px;">www.abc.com/a/slide1.html</TD><TD style="padding: 2px;">100</TD></TR><TR><TD style="padding: 2px;"><P>www.abc.com/a/slide2.html</P></TD><TD style="padding: 2px;">90</TD></TR><TR><TD style="padding: 2px;">www.abc.com/a/slide3.html</TD><TD style="padding: 2px;">80</TD></TR><TR><TD style="padding: 2px;">www.abc.com/b/slide1.html</TD><TD style="padding: 2px;">100</TD></TR><TR><TD style="padding: 2px;">www.abc.com/b/slide2.html</TD><TD style="padding: 2px;">90</TD></TR><TR><TD style="padding: 2px;">www.abc.com/b/slide3.html</TD><TD style="padding: 2px;">80</TD></TR><TR><TD style="padding: 2px;">www.abc.com/c/slide1.html</TD><TD style="padding: 2px;">100</TD></TR><TR><TD>www.abc.com/c/slide2.html</TD><TD>90</TD></TR><TR><TD>www.abc.com/c/slide3.html</TD><TD>80</TD></TR></TBODY></TABLE><P></P><P>The funnel should only report on slides, so:</P><P></P><P>Slide1 : 300</P><P>Slide2 : 270</P><P>Slide3 : 240</P><P></P><P>I first tried it with a dynamic dimension e.g.:</P><P>=If(SubStringCount(Pages, 'slide1')&gt; 0, Pages) </P><P></P><P>But this is not giving me the results i wanted as this would have three results for Slide1 (www.abc.com/a,www.abc.com/b,www.abc.com/c)</P><P></P><P>Do you have any ideas how to visualize that?</P></BODY></HTML> Tue, 27 Oct 2015 11:48:15 GMT 2015-10-27T11:48:15Z Grouping Dimension Values for a Funnel Diagramm https://community.qlik.com/t5/QlikView/Grouping-Dimension-Values-for-a-Funnel-Diagramm/m-p/971320#M526945 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I want to create a funnel diagramm to show how deep visitors are digging into the content of the page. The data looks somehow like this:</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">Pages</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Hits</TH></TR><TR><TD style="padding: 2px;">www.abc.com/a/slide1.html</TD><TD style="padding: 2px;">100</TD></TR><TR><TD style="padding: 2px;"><P>www.abc.com/a/slide2.html</P></TD><TD style="padding: 2px;">90</TD></TR><TR><TD style="padding: 2px;">www.abc.com/a/slide3.html</TD><TD style="padding: 2px;">80</TD></TR><TR><TD style="padding: 2px;">www.abc.com/b/slide1.html</TD><TD style="padding: 2px;">100</TD></TR><TR><TD style="padding: 2px;">www.abc.com/b/slide2.html</TD><TD style="padding: 2px;">90</TD></TR><TR><TD style="padding: 2px;">www.abc.com/b/slide3.html</TD><TD style="padding: 2px;">80</TD></TR><TR><TD style="padding: 2px;">www.abc.com/c/slide1.html</TD><TD style="padding: 2px;">100</TD></TR><TR><TD>www.abc.com/c/slide2.html</TD><TD>90</TD></TR><TR><TD>www.abc.com/c/slide3.html</TD><TD>80</TD></TR></TBODY></TABLE><P></P><P>The funnel should only report on slides, so:</P><P></P><P>Slide1 : 300</P><P>Slide2 : 270</P><P>Slide3 : 240</P><P></P><P>I first tried it with a dynamic dimension e.g.:</P><P>=If(SubStringCount(Pages, 'slide1')&gt; 0, Pages) </P><P></P><P>But this is not giving me the results i wanted as this would have three results for Slide1 (www.abc.com/a,www.abc.com/b,www.abc.com/c)</P><P></P><P>Do you have any ideas how to visualize that?</P></BODY></HTML> Tue, 27 Oct 2015 11:48:15 GMT https://community.qlik.com/t5/QlikView/Grouping-Dimension-Values-for-a-Funnel-Diagramm/m-p/971320#M526945 2015-10-27T11:48:15Z Re: Grouping Dimension Values for a Funnel Diagramm https://community.qlik.com/t5/QlikView/Grouping-Dimension-Values-for-a-Funnel-Diagramm/m-p/971321#M526946 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>May be like this...</P><P><IMG alt="Capture.JPG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/103341_Capture.JPG" style="height: auto;" /></P></BODY></HTML> Wed, 28 Oct 2015 13:33:59 GMT https://community.qlik.com/t5/QlikView/Grouping-Dimension-Values-for-a-Funnel-Diagramm/m-p/971321#M526946 settu_periasamy 2015-10-28T13:33:59Z