Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
baarathi
Creator III
Creator III

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
Specialist II
Specialist II

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

Hope this will work for you.

Regards,
Vishal Waghole
baarathi
Creator III
Creator III
Author

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

Channa
Specialist III
Specialist III

 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