Qlik Community

Ask a Question

New to Qlik Sense

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

Announcements
Join us March 10th, 7 ways modern analytics can help you take smarter action. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
BIDev
Creator
Creator

Bar chart in Qliksense

I have data as below.

CityDateAmount
Austin1/4/20205000
Dallas1/1/20207000

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 ?

1 Solution

Accepted Solutions
Anil_Babu_Samineni

You mean like this?

Anil_Babu_Samineni_0-1609873323719.png

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)

View solution in original post

15 Replies
Anil_Babu_Samineni

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)
BIDev
Creator
Creator

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

Anil_Babu_Samineni

Is this not what you need?

Anil_Babu_Samineni_0-1609867648469.png

 

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)
BIDev
Creator
Creator

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

 

CityDateAmount
Austin1/4/20205000
Dallas1/1/20207000
Houston1/1/20203000
Anil_Babu_Samineni

You mean like this?

Anil_Babu_Samineni_0-1609873323719.png

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)

View solution in original post

BIDev
Creator
Creator

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.

Anil_Babu_Samineni

like this? If so, Add another dimension as City 

Anil_Babu_Samineni_0-1609948214627.png

 

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)
BIDev
Creator
Creator

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

 

 

Anil_Babu_Samineni

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)