Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Josh
Contributor II
Contributor II

Formula using P

Hey all. 

So I have this formula and it works for the case use I apply it for but it only works when I have selected a specific field. Or when I use it in a KPI. But graphs and tables don't play nice with it. I was wondering if someone could explain how qlik is reading this formula and what I am "actually" telling it to do. 

(count( {<session_id = ( p({<quiz_type={1}>}) * p({<event_type={305}>}) ) >} distinct session_id))
/
(Count({<event_type={36}>} Distinct session_id))

This is one formula designed to make a rate. I only wanted to count those people who took a quiz and performed an event called 305. When I select a particular field to filter by this works. But as a whole this does not work. Can any one assist in explaining what this formula is doing? 

 

Thank you!

Labels (2)
3 Replies
prabhu0505
Specialist
Specialist

Since you didn't mention Set Identifier (1 or $) in your Set Analysis expressions explicitly, it'll be $ by default. In that case user filter gets applied first and all Set Analysis filters (quiz_type={1} & event_type={305}) will stacked/cascaded on top of it. Now evaluate your app/data with this fundamentals.

 

Josh
Contributor II
Contributor II
Author

But I want the filters to stack. What I am saying is that, when I have no filters selected, it does not work properly. But If I do select a filter it works how I want it to. 

prabhu0505
Specialist
Specialist

If possible attach sample app