Skip to main content
Announcements
See why Qlik is a Leader in the 2024 Gartner® Magic Quadrant™ for Analytics & BI Platforms. Download Now
cancel
Showing results for 
Search instead for 
Did you mean: 
settu_periasamy
Master III
Master III

function to check the column header or row header is 'total'

Hi Team,

I need to do one expression, if the the column header or row header is 'total'.

is there any string function to check the column header and row header is 'Total', If i use the dimensionality() and secondary dimensionality, not getting the expected result when we do the collapse and expand.

Just i need to check, if the column header or row header is total, then do some expression.

Find the below pivot table for your reference.

Picture2.jpg

Thanks in Advance.

Regards,

Sethu

1 Reply
Anonymous
Not applicable

You can use Dimensionality=Max(Dimensionality) for total columns but for total rows the expressinon SecondaryDimensionality=Max(SecondaryDimensionality()) doesnt work