topic Re: Formula using P in App Development

Formula using P

Josh — Sat, 16 Nov 2024 03:48:54 GMT

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!

Re: Formula using P

prabhu0505 — Mon, 16 Dec 2019 20:19:46 GMT

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.

Re: Formula using P

Josh — Mon, 16 Dec 2019 21:18:36 GMT

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.

Re: Formula using P

prabhu0505 — Mon, 16 Dec 2019 21:31:34 GMT

If possible attach sample app