Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
chilz
Contributor II
Contributor II

SecondaryDimensionality() in Pivot Table - What are the dimesions

So I am trying to build a pivot table while calculating the percentage based on the selected SecondaryDimensionality() and the "SecondaryDimensionality" function does provide how many secondary dimensions added in the pivot but it does not provide what are those dimension.

Right now my expression sounds like this:

chilz_0-1609134513589.png

I would like to be able to make this equation dynamic, using a function if possible or any other mean.

Thanks

Labels (3)
2 Replies
Anil_Babu_Samineni

To make dynalic, How you will be producing into dynamic of ignore fields?

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
chilz
Contributor II
Contributor II
Author

Table are not supposed to be filtered by any selection if this what you mean