What I have is dimension called Funnel Steps (steps in conversion funnel) and measure Funnel Amount (conversions in each step). If I use a funnel chart then I get a funnel with measures of number values. I also need relative measure in precentage (conversion rate) of how many users converted from each step to the next. So in this simple example I would also like to see precentage of how many CC Visits converted into carconfigurator usage.
Probably You are right and it can't be visualized on the same chart but question still remains how to create a measure in Qlik Sense?
I tried to use such expression when creating measure if(wildmatch([Funnel Step],'carconfigurator'),sum([Funnel Amount])) / if(wildmatch([Funnel Step],'CC Visits'),sum([Funnel Amount])) This doesn't work. Is it even possible to sum values in one column depending on values in another? It seems so basic to me and sumif does it in Excel. How can it be done in Sense, in particular how to create measure in such way?