topic Re: Pivot Table Headings in QlikView

Pivot Table Headings

priyarane — Wed, 30 Sep 2015 06:24:41 GMT

Hi Community,

I need to put headings like I have attached.

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

Digvijay_Singh — Wed, 30 Sep 2015 07:01:35 GMT

See attached, almost matching

priyarane — Wed, 30 Sep 2015 07:07:59 GMT

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

Wed, 30 Sep 2015 07:21:41 GMT

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

Digvijay_Singh — Wed, 30 Sep 2015 07:49:02 GMT

As Benoit suggested you can do like this -

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