Bar chart in Qliksense

[BI_Dev]

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 ?

[Anil_Babu_Samineni]

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

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

[BI_Dev]

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?

[BI_Dev]

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

[Anil_Babu_Samineni · Accepted solution]

You mean like this?

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

[BI_Dev]

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 

[BI_Dev]

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

[Anil_Babu_Samineni]

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