Total by selected dimensions except one

Daniel_BI2024 — Thu, 04 Apr 2024 09:21:04 GMT

Hi All,

I have the following formula, and I want to get the total campaigns' installs without the events split.

the formula is:

sum( total<campaign_number> {<action_name= >} Installs)

for this example, the campaigns' total installs are: 3,000

the installs per event:

purchase: 500

add to card: 1000

order:1500

I'm getting a correct installs per campaign, but when I choose specific event I missing installs, it means that when I Choose 'purchase' and 'add to card' I'm getting only 1,500 installs and I want to get all the 3,000 installs.

Appreciate it a lot if someone can help me to solve it!

Re: Total by selected dimensions except one

Daniel_BI2024 — Sat, 06 Apr 2024 10:09:33 GMT

Hi,

My question above is still relevant, I haven't solved it yet.

Thanks in advance for any assistance, I appreciate it a lot!

topic Re: Total by selected dimensions except one in QlikView

Total by selected dimensions except one

Re: Total by selected dimensions except one