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

settu_periasamy — Tue, 19 Aug 2014 02:44:50 GMT

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.

Thanks in Advance.

Regards,

Sethu

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

Anonymous — Tue, 30 Sep 2014 08:50:25 GMT

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

topic function to check the column header or row header is 'total' in QlikView

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

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