Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Highlighted
shannoypaul
Contributor

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
Employee
Employee

Re: How to achieve the following by using a Bar Chart?

An workaround

capture.png

5 Replies
vikasmahajan
Esteemed Contributor

Re: How to achieve the following by using a Bar Chart?

Hello

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

Vikas

Partner
Partner

Re: How to achieve the following by using a Bar Chart?

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.

Employee
Employee

Re: How to achieve the following by using a Bar Chart?

An workaround

capture.png

shannoypaul
Contributor

Re: How to achieve the following by using a Bar Chart?

Thank You!

shannoypaul
Contributor

Re: How to achieve the following by using a Bar Chart?

Thank You!