Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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.
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.
If possible attach sample app