Qlik Community

Ask a Question

Qlik Sense Advanced Authoring

Discussion board where members can learn more about Qlik Sense Advanced Authoring.

Talk to Experts Tuesday, January 26th at 10AM EST: Qlik Sense. REGISTER NOW
Showing results for 
Search instead for 
Did you mean: 

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 

1 Reply

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...