Aggregated Dimension value

[baarathi]

I have stacked bar chart. With Dimension values A,B,C. So totally i have three bars. I want 4th bar which aggregates A,B and C values and 4th bar with name as ALL.

[VishalWaghole]

Please refer attached images.
You need to do some changed at data model level.

Hope this will work for you.

Regards,
Vishal Waghole

[baarathi]

@VishalWaghole  But is there a approach to achieve this though chart expression rather than going to load script. 

[Channa]

 in qlik sense

you need to add one more select for total and do

concatenate

try

Dimension:

LOAD Distinct Dimension , dimension2 from  MyTable;

Concatenate(Dimension )

LOAD Distinct 'Total' as Dimension , dimension2 Resident MyTable;