topic Re: Sub columns in pivote table in QlikView

Sub columns in pivote table

Thu, 14 Feb 2013 09:01:00 GMT

Hello,

I want to create sub colums in Pivot table.

I know we need to drag 1 dimension over the expressions and create the subcolumns for all the columns in expressions.

But I dont want in this way.

I have 5 columns, out of which for 2 columns i need 1 sub column and for other 2 columns diff sub column and 1 column without any sub column.

I would like to know is it possible? If yes how? and if not any work around for the same?

Below is the format I need.

Thu, 14 Feb 2013 09:18:21 GMT

Hi apurvapetkar,

Did you forget to add the example layout that you want. Might be able to help if I can see what you're trying to achieve.

Mike.

Thu, 14 Feb 2013 09:35:59 GMT

sorry missed the image.

Please check the attached image.