Vertical Dimension into horizontal

Mon, 06 Sep 2010 11:50:07 GMT

Dear All,

I am facing a problem with some reports I have been trying to create.

I have the following object.

And in order to make the report more user-freindly and easier to read I would like it to look like this;

Here, the Balances B and F are grouped under each the Assets and Liabilities.

I have searched in the forums and found these two solution, but I have not been able to work any of them.

http://community.qlik.com/forums/t/19453.aspx

http://community.qlik.com/forums/t/30084.aspx using a macro, though i would prefer not to use one

Is there any way where I can use a merged header or something of the like where both balance B and F are grouped under Assets at the and under liabilities as well.

Or if someone could tell me how to use the NumberOfLeftDimensions property, then that would be af great help.

Looking forward for your replies, thanking you in advance.

Best Regards,

Sadri

Vertical Dimension into horizontal

Mon, 06 Sep 2010 11:56:52 GMT

Hi,

Try with a pivot table... There you can convert horizontal column into a vertical column...

Regards,

Nilupa

Vertical Dimension into horizontal

Mon, 06 Sep 2010 12:05:37 GMT

Hi,

Thanks for your reply.

I've tried doing it with a pivot table, but I couldnt figure out how to.

Can you give me any pointers?

Regards,

Sadri

topic Vertical Dimension into horizontal in QlikView

Vertical Dimension into horizontal

Vertical Dimension into horizontal

Vertical Dimension into horizontal