Ahh - the wonderful world of Finance Reporting in Qlikview - it's the bain of my life.
The best example I've found is from the Share Qlikviews page: http://community.qlik.com/media/p/122153.aspx It's probably more complex than you need (or expected) but should provide you with some pointers - the Excel 'control sheet' is by far the best method I've found.
I also came up with a similar method using the rangesum() and above() functions so for your row 3 you'd have something similar to rangesum(above(Sales,2)) with the 2 being assigned to the subtotal via a value in the script and also having a 'level' designation to control which expression to use...a total pain beginning to end.
This is the area that Qlikview really falls down on - or doesn't even try to achieve; you can get there as the above shows but it's nigh on un-workable and very time consuming. One other option would be to look at QvExcel from Industrial Codebox which allows you to handle the Excel style formatting in Excel which is surely the best place for it!?
Hope that helps and Good Luck!
Matt - Visual Analytics Ltd
If you would like an online demo of QVExcel please feel free to contact me directly - you can also see some sample financial reports at:
And also download a free evaluation of QVExcel there.
Yes this is what i was looking for but it bit more simple than what i want. Still this will help in acheiving the result.
Thanks a lot for this.
I'm able to produce what i want now but Format of the totals is working in the sample qvw but when i use the same in mine it does not bold or italise the row, i dont understand why?
Could you please help me in that. I have also used the same table PLFormat in my qvw and joined it to the type column as in PLData table.
This post is a few months old now I'm interested in looking at the example that Matt has referred to in his reply post. The link to the Share QlikViews page no longer works. Does anyone know where I can get hold of the example that he referred to http://community.qlik.com/media/p/122153.asp?