topic Re : Heading in pivot table in QlikView

Re : Heading in pivot table

Wed, 18 Mar 2015 13:38:52 GMT

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..

Re: Re : Heading in pivot table

sunny_talwar — Wed, 18 Mar 2015 13:42:24 GMT

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,

Re: Re : Heading in pivot table

awhitfield — Wed, 18 Mar 2015 14:05:24 GMT

Or use a text box with the heading in

Re: Re : Heading in pivot table

Wed, 18 Mar 2015 19:02:01 GMT

hii..

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

Re: Re : Heading in pivot table

sunny_talwar — Wed, 18 Mar 2015 20:22:58 GMT

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,

Re: Re : Heading in pivot table

Thu, 19 Mar 2015 05:33:25 GMT

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

Re: Re : Heading in pivot table

Thu, 19 Mar 2015 11:41:18 GMT

HII...

ANY HELP ON THIS.. PLEASE...

Re: Re : Heading in pivot table

awhitfield — Thu, 19 Mar 2015 11:47:14 GMT

Have you tried my Text box idea?

Andy

Re: Re : Heading in pivot table

Thu, 19 Mar 2015 11:49:21 GMT

hi..

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

Re: Re : Heading in pivot table

sunny_talwar — Thu, 19 Mar 2015 12:07:05 GMT

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,

Re: Re : Heading in pivot table

awhitfield — Thu, 19 Mar 2015 12:15:08 GMT

Have a look at this thread, it may help:

http://community.qlik.com/thread/3098

Andy

Re: Re : Heading in pivot table

Thu, 19 Mar 2015 12:17:13 GMT

hi...

thank yu...

yea.. i have to hide those two null fields.

Re: Re : Heading in pivot table

awhitfield — Thu, 19 Mar 2015 12:36:45 GMT

Hi Reenaabraham,

can you post a sample of the data you are loading please?

Andy

Re: Re : Heading in pivot table

awhitfield — Thu, 19 Mar 2015 12:40:00 GMT

Here's another useful looking post

http://community.qlik.com/thread/63353

Re: Re : Heading in pivot table

sunny_talwar — Thu, 19 Mar 2015 14:33:41 GMT

Tried another method with some manipulation in the script. See if this is something which you can do with your more complicated script or not.

Best,