Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Now Live: Qlik Sense SaaS Simplified Authoring – Analytics Creation for Everyone: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
shannoypaul
Creator
Creator

How to achieve the following by using a Bar Chart?

Dimension1: Month

Dimension2: City

Fact1: Forecast

Fact2: Budget

Fact3: Actual

Chart.jpg

1 Solution

Accepted Solutions
Clever_Anjos
Employee
Employee

5 Replies
vikasmahajan

Hello

Create dummy data in excel and attach so that anybody can help you.

Vikas

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution.
If you want to go quickly, go alone. If you want to go far, go together.
agilos_mla
Partner - Creator III
Partner - Creator III

Hi  it's not possible to achiveve this layout, when using multiple expressions with at least two dimensions the bar chart turns automatically into stacked bar.

Look at this post.

http://community.qlik.com/thread/103307

A way to achieve sthg very similiar is to create a calculated dimension by concatening the strings City-Month, then you'll have one single dimension, the tricky thing is how to define a correct sort order. (simplest way is in the script)

Michael.

Clever_Anjos
Employee
Employee

An workaround

capture.png

shannoypaul
Creator
Creator
Author

Thank You!

shannoypaul
Creator
Creator
Author

Thank You!