Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
Try with a pivot table... There you can convert horizontal column into a vertical column...
Regards,
Nilupa
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