Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Re : Heading in pivot table

     Hi All..

i need to create a pivot table as follows

Here Discipline is the dimension and Rest all are Expression

i have to create an additional Heading ,(Productivity,Lock Up etc..) for specific Expressions as shown below.

is there Any possible way to achieve this??

please suggest..

14 Replies
Highlighted

Re: Re : Heading in pivot table

You can use ValueList() function to create a new dimension:

Something like this:

ValueList('PRODUCTIVITY', 'LOCK UP' and so on...)

and then use that within your expression like this:

If(ValueList('PRODUCTIVITY', 'LOCK UP' and so on...) = 'PRODUCTIVITY',

yourExpression) for your Hours expression

HTH

Best,

S

Highlighted
Partner
Partner

Re: Re : Heading in pivot table

Or use a text box with the heading in

Highlighted
Not applicable

Re: Re : Heading in pivot table

hii..

I tried tht ..bt it is nt working.all values are coming under the same.

Highlighted

Re: Re : Heading in pivot table

Are you using the same if for all of them? For Dbors TOTAL you need to do like this:

If(ValueList('PRODUCTIVITY', 'LOCK UP' and so on...) = 'LOCK UP',

yourExpression) for your Dbors TOTAL expression.

Need to make sure that you select the correct place to put your expressions.

Let me know if it is still not clear.

Best,

S

Highlighted
Not applicable

Re: Re : Heading in pivot table

yea,...i have done the same. in expression field i have given the same.

Highlighted
Not applicable

Re: Re : Heading in pivot table

HII...

ANY HELP ON THIS.. PLEASE...

Highlighted
Partner
Partner

Re: Re : Heading in pivot table

Have you tried my Text box idea?

AndyPicture 2015-03-19 11_45_45.png

Highlighted
Not applicable

Re: Re : Heading in pivot table

hi..

but while exporting to excel the text box cannit be exported ..so i cant use tht way...

Highlighted

Re: Re : Heading in pivot table

So I have this thus far. May be somebody knows a way to remove the empty columns where all the values are null. i tried doing suppress null value but that did not help. Attaching my qvw for others to play with.

Best,

S