Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Grouping Dimension Values for a Funnel Diagramm

Hi,

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:

PagesHits
www.abc.com/a/slide1.html100

www.abc.com/a/slide2.html

90
www.abc.com/a/slide3.html80
www.abc.com/b/slide1.html100
www.abc.com/b/slide2.html90
www.abc.com/b/slide3.html80
www.abc.com/c/slide1.html100
www.abc.com/c/slide2.html90
www.abc.com/c/slide3.html80

The funnel should only report on slides, so:

Slide1 : 300

Slide2 : 270

Slide3 : 240

I first tried it with a dynamic dimension e.g.:

=If(SubStringCount(Pages, 'slide1')> 0, Pages)

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)

Do you have any ideas how to visualize that?

1 Reply

Re: Grouping Dimension Values for a Funnel Diagramm

Hi,

May be like this...

Capture.JPG

Community Browser