Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

'TOTAL' in GRID CHARTS

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

2 Replies
israrkhan
Valued Contributor II

Re: 'TOTAL' in GRID CHARTS

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

Re: 'TOTAL' in GRID CHARTS

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:

Product
Apple
Banana
Chocolate

The new table would look like this:

ReportProductProduct
AppleApple
BananaBanana
ChocolateChocolate
TotalApple
TotalBanana
TotalChocolate

Now you can use ReportProduct in the grid chart instead of Product to show the totals too.


talk is cheap, supply exceeds demand
Community Browser