Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
ZootopiaWorld
Contributor
Contributor

Count total in a pivot of all Id's discarding any relation except 2 selection fields

I want to calulate the total number of id's X discarding any relation, except 2 . 

1) field 1

2) field 2

In my current calculation  there seems to be a relation which it would like to discard.

How can I create a formula where I can calculate totals only using 2 variables 

Labels (1)
1 Reply
ZootopiaWorld
Contributor
Contributor
Author

count (distinct total <Week> Customer)

This is my current calculation, but it gives as result it only counts the Customers who are in an combined dimension.

What I would like is that this formula only look at Week as a variable and Name as avariable. And that it discards every other interaction/connection in the data.

How can I make a formula saying, Count Total customers and only take into account Week and Name 

It's my first forum post, so I hope my question is clear...