# New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld Online 2021, May 10-12: Our Free, Virtual, Global Event REGISTER TODAY
cancel
Showing results for
Did you mean:
Creator

## Bar chart in Qliksense

I have data as below.

 City Date Amount Austin 1/4/2020 5000 Dallas 1/1/2020 7000

I want a bar chart with Date as dimension and then I want to show Amount measure, but inside the bar I want to show city name vs amount..is this doable ?

Labels (6)

• ### swuel

1 Solution

Accepted Solutions

You mean like this?

Measure : Dual(Concat(City &':'& Amount,Chr(10)), Sum(Amount))

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
15 Replies

Try like this as measure and see if that give shot?

Dual(City & ':' & Sum(Amount), Sum(Amount))

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Creator
Author

Thank you, but this did not add city name to the bar..instead it shows amount.

Is this not what you need?

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Creator
Author

Yeah - Thank you much..this is what I want,

I have a scenario where 2 cities has the same date.Can I stack by City ? If I pick 1/1/2020,stack bar with Dallas and Houston Amount

 City Date Amount Austin 1/4/2020 5000 Dallas 1/1/2020 7000 Houston 1/1/2020 3000

You mean like this?

Measure : Dual(Concat(City &':'& Amount,Chr(10)), Sum(Amount))

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Creator
Author

Yeah - almost...request I have is to stack bar by city...like Dallas will have 1 stack & Houston will have the second stack..Thank you much.

like this? If so, Add another dimension as City

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Creator
Author

Yeah - i tried that but for some reason I only see numbers inside the stack & not city.I have the same expression though.

May be share some sample application also show your dim and measures how it is?

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)