Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
BrunPierre
Master
Master

Count display items from the dimensions as expressions in a pivot table

peter_brown_0-1589970737516.png

Hello Guys,

With reference to the image above, I would want to count distinctly the values under the column Mobile, DOB & Mail, and display as highlighted in the light blue background.

I tried, IF(Dimensionality()= 3, count (distinct Mobile), but results were incorrect.

 

3 Replies
sunny_talwar

Can you elaborate on what was incorrect? What did you get and what were you hoping to see? Can you may be provide a sample to check this out?

BrunPierre
Master
Master
Author

Hi

The results were null '-' and the desired result is attached below. Essentially, where the dimension value is not blank/null/empty count and display totals.

peter_brown_0-1589978514438.png

 

sunny_talwar

What if you just used Count (DISTINCT Mobile)?