Discussion Board for collaboration related to QlikView App Development.
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.
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?
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.
What if you just used Count (DISTINCT Mobile)?