Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

baarathi
Contributor II

Aggregated Dimension value

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

3 Replies
VishalWaghole
Valued Contributor II

Re: Aggregated Dimension value

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

Hope this will work for you.

Regards,
Vishal Waghole
baarathi
Contributor II

Re: Aggregated Dimension value

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

Channa
Valued Contributor III

Re: Aggregated Dimension value

 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;

Channa