Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
vizchanger
Contributor
Contributor

Front End: Concat 2 rows barchart

Morning,

I have a bar chart. The dimension is  County and the measure is Population.

County Population
Montogomery 4000
Charles 3000
Montgomery-2 200

 

I only want to concat Montgomery and Charles into 1 bar chart.

I tried this concat(County,'Montogomery','Charles') as M&C 

This is all a front end change for this bar chart only. 

Labels (4)
1 Reply
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

As your chart dimension, use a calculated Dimension:

if (Match(County, 'Montogomery', 'Charles'), 'M&C', County)

-Rob