Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

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
Highlighted

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?

Highlighted
Contributor III
Contributor III

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

 

Highlighted

What if you just used Count (DISTINCT Mobile)?