Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Read about the latest Qlik Community enhancements on the Community News blog!
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>)