Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik and ServiceNow Partner to Bring Trusted Enterprise Context into AI-Powered Workflows. Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Firefly
Contributor II
Contributor II

Count of multiple Dimensions in single pivot

Firefly_0-1649324506532.jpeg

Is it possible to use dimentionality and total to count the instances of each dimension by the dimension in column a. 

currently able to get the first instance of the count using 

=if(Dimensionality()=1,count(total< [Category]> Category_desc) but need to expand this to calculate on mutliple dimensions. 

 

 

 

Labels (3)
1 Reply
marcus_sommer

I'm not sure if you really need the total within the count() and would rather expect that distinct would be useful. Therefore I could imagine that you use something like this:

if(dimensionality() = 1, count(distinct Category_desc&AnotherField), ...) 

- Marcus