Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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