Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
priyarane
Specialist
Specialist

Pivot Table Headings

Hi Community,

I need to put headings like I have attached.

In the worksheet(Table) - Data, and Output work sheet - looking output like that.

1 Solution

Accepted Solutions
Not applicable

Hi Priya,

I think it doesn't exist a simple solution to avoid total in indent mode.

You can try adding a test with dimensionality in your expression, but this solution will be bad for the display perfomances.

Example :

=if(Dimensionality()>1,

      sum(Field)

,'') // if total then change expression to empty string

View solution in original post

4 Replies
Digvijay_Singh

See attached, almost matching

pivot.PNG

priyarane
Specialist
Specialist
Author

Hi Digvijay,

In indent mode, total will come but as per my requirement I don't need total...is there any way to avoid total in indent mode

Not applicable

Hi Priya,

I think it doesn't exist a simple solution to avoid total in indent mode.

You can try adding a test with dimensionality in your expression, but this solution will be bad for the display perfomances.

Example :

=if(Dimensionality()>1,

      sum(Field)

,'') // if total then change expression to empty string

View solution in original post

Digvijay_Singh

As Benoit suggested you can do like this -

if(Dimensionality()=1,'',<Your Exp>)