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

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
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