Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Modified bar chart

Hi

I have two tables

Table A

ID, AccountNo, FinancialYear, BudgetTotal, Commitments

1,     1,               2015,               6000,           500

Table B

ID, FinancialYear, FinancialMonth, ActualExpenditure

1,       2105,               Jan,                450

1,       2105,               Feb,                550

1,       2105,               Mar,                400

1,       2105,               Apr,                450

1,       2105,               May,               550

1,       2105,               Jun,                450

In table A we have one record per year per account, Table B keeps expenses per month.

Now I need to Create a bar chart with the first being a stacked bar chart with sum(ActualExpenditure) from Table B and sum(Commitments) from tableA. Then in a second bar I need sum(BudgetTotal)

The bar chart then would show 2850 as ActualExpenditure and 500 as Commitments in the stacked chart, and the 6000 as BudgetTotal in a second bar

Any suggestions on how to get this.

4 Replies
nagarjuna_kotha
Partner - Specialist II
Partner - Specialist II

Hi,

PFA and let me know in case of any queries

-Nagarjun.

Not applicable
Author

I have seen something similar in a previous question. My inforrnation though is on two different tables The information on the bar chart is on two separate tables than I cannot load into Qlikview as one to be able to use the dimension field idea

Peter_Cammaert
Partner - Champion III
Partner - Champion III

In the chart of the above example document (nice work btw nagarjuna.kothamandi), disable Show Legend and Label for Dim_2 (in tab Dimensions).

If you don't want to create an extra field in your script just to show two bars side-by-side, you can use the ValueList() function in a calculated dimension instead of Dim_2. ValueList() will create a synthetic dimension on the spot.

For example, replace Dim_2 with this expression:

=ValueList('Stack', 'Group')

And in your expressions, replace the test for a particular Dim_2 value with:

=IF(ValueList('Stack', 'Group') = 'Stack', Sum(Expr_N))

or

=IF(ValueList('Stack', 'Group') = 'Group', Sum(Expr_N))

Best,

Peter

Peter_Cammaert
Partner - Champion III
Partner - Champion III

Doesn't matter. As long as you have a link between the two tables, this will work.

For an alternative to the second (artificial) dimension, see my post below.