Qlik Community

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Read about the latest Qlik Community enhancements on the Community News blog!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Calculate funnel conversion rate

Hi all,

I am trying to create a conversion rate funnel for an ecommerce page. To achieve that I count visitors who visited a page and divide the number by total visitors of the previous page.

My formula with first page = LandingPage and second page = UserInput


idvisit = visits/ visitors

page = name of the page


Logic: Visitors of UserInput who came from LandingPage divided by total visitors of LandingPage

count(

{$<idvisit = p({1<page={'LandingPage'}>}),

page={'UserInput'}>} distinct(idvisit)

)

/

count(

{$<page={'LandingPage'}>} distinct(idvisit)

)

Could somebody tell me if my formula is correct?

Any help is much appreciated!

0 Replies