Discussion Board for collaboration related to QlikView App Development.
Hi, i want to display the data in cross tabular format in straight table.For reference see the attachment.
How about using a Pivot Table with the Always Fully Expanded option ticked to it looks like a Straight Table
you Need to define 12 expressions (for each month one and use set Analysis in each Expression)
and so forth
I would do this Job only if customer really Needs it and Pivot table is not possible or allowed
Why you dont want use a pivot like this?
You just specify how we do above scenario in pivot?
As I do in the file that you can find in my post you do this:
- create a pivot table ad insert Year and Month in dimension, sum(sales) in expression,
- drag and drop Month from column to row;
- in the presentation tab of the pivot table select Year (NOT Month) dimension and tyck Show Partial Total:
Thanks for Reply. Is their any way in straight tables except set expressions.
I think that you should use set expression in the straight table.