Qlik Community

App Development

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

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
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