topic 'TOTAL' in GRID CHARTS in QlikView

'TOTAL' in GRID CHARTS

Mon, 02 Dec 2013 10:01:53 GMT

Hi all,

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.

Regards,

Susvith

israrkhan — Mon, 02 Dec 2013 10:18:58 GMT

Hi,

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...

Gysbert_Wassenaar — Mon, 02 Dec 2013 14:42:40 GMT

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.