Skip to main content
Announcements
See why Qlik is a Leader in the 2024 Gartner® Magic Quadrant™ for Analytics & BI Platforms. Download Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Daniel_BI2024
Contributor
Contributor

Total by selected dimensions except one

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!

Labels (2)
1 Reply
Daniel_BI2024
Contributor
Contributor
Author

Hi,

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

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