Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

cancel
Showing results for 
Search instead for 
Did you mean: 
chan103148
Contributor III
Contributor III

conversion rate

good day,

 

need help

I need to compute for conversion rate by dividing Traffic count from Transaction count,

 

problem is there are dates that have no foot traffic count, that causes abnormality in my data.

I want to include only Transaction count with corresponding Traffic count greater than zero on a daily basis.

current script:

(Count({$<[Date.autoCalendar.Year]= {"2020"}>} distinct [Transaction Number]))

/

(Sum({$<[Date.autoCalendar.Year]={"2020"},[Traffic In]={">0"}>}[Traffic In]))

 
 

Capture.JPG

in the graph above, the computed Conversion rate is 22% which should be 4% only

advance thankyou,

Christian

Labels (2)
0 Replies