Discussion Board for collaboration on QlikView Layout & Visualizations.
How to display the total on both sides(horizontal and Vertical) in a grid chart?
PS: just like attached excel snapshot
any help would be appreciated.
Grid Chart Shows data in Symbol/ graphical way, not in text format..
i think you cant do it,
But, you can create label object and place them below each total, and set layout >> layer property to top, for all labels.
and in label you can use the expression to calculate totals.
it might work...
It should be possible if you create two new dimensions in the script based on the two you use in the chart. Suppose you have a dimension Product:
The new table would look like this:
Now you can use ReportProduct in the grid chart instead of Product to show the totals too.