Stacked chart problem

Anonymous — Sun, 17 May 2015 12:44:05 GMT

Hi Geniuses,

I have the below data

ACCOUNT_LABEL	HCBU	HCEntity	HCMonth	HCScenario	HCTypes	HCView	HCYear	Headcount
HC1000T	1215000	MDCMGMT	Jan	Actual_Interim	Emiratis	YTD	2015	1
HC1000T	1215000	MDCMGMT	Jan	Actual_Interim	Emiratis	YTD	2015	4
HC1000T	1215000	MDCMGMT	Jan	Actual_Interim	Expats	YTD	2015	2
HC1000T	1215000	MDCMGMT	Jan	Actual_Interim	Expats	YTD	2015	4
HC1000T	1215000	MDCMGMT	Jan	Actual_Interim	TotalHeadCount	YTD	2015	3
HC1000T	1215000	MDCMGMT	Jan	Actual_Interim	TotalHeadCount	YTD	2015	8
HC1000T	1331000	MDCMGMT	Jan	Actual_Interim	Emiratis	YTD	2015	25
HC1000T	1331000	MDCMGMT	Jan	Actual_Interim	Expats	YTD	2015	12
HC1000T	1331000	MDCMGMT	Jan	Actual_Interim	TotalHeadCount	YTD	2015	37
HC1000T	1425600	MDCMGMT	Jan	Actual_Interim	Emiratis	YTD	2015	72
HC1000T	1425600	MDCMGMT	Jan	Actual_Interim	Expats	YTD	2015	77
HC1000T	1425600	MDCMGMT	Jan	Actual_Interim	TotalHeadCount	YTD	2015	149
HC1000T	1425800	MDCMGMT	Jan	BudgetUpdated	Emiratis	YTD	2015	26
HC1000T	1425800	MDCMGMT	Jan	BudgetUpdated	Expats	YTD	2015	38
HC1000T	1425800	MDCMGMT	Jan	BudgetUpdated	TotalHeadCount	YTD	2015	64
HC1000T	1713000	MDCMGMT	Jan	BudgetUpdated	Emiratis	YTD	2015	17
HC1000T	1713000	MDCMGMT	Jan	BudgetUpdated	Expats	YTD	2015	24
HC1000T	1713000	MDCMGMT	Jan	BudgetUpdated	TotalHeadCount	YTD	2015	41

I am using the formula for Emiratis actual values =num(Sum({<HCMonth = {$(=vMonth)},HCScenario={'Actual_Interim'},HCTypes={'Emiratis'},YEARID = {$(=YearVariable)}>} Headcount) ,'#,##0;(#,##0)')

Expats actual values =num(Sum({<HCMonth = {$(=vMonth)},HCScenario={'Actual_Interim'},HCTypes={'Expats'},YEARID = {$(=YearVariable)}>} Headcount) ,'#,##0;(#,##0)')

Emiratis Budget values =num(Sum({<HCMonth = {$(=vMonth)},HCScenario={'BudgetUpdated'},HCTypes={'Emiratis'},YEARID = {$(=YearVariable)}>} Headcount) ,'#,##0;(#,##0)')

Expats actual values =num(Sum({<HCMonth = {$(=vMonth)},HCScenario={'BudgetUpdated'},HCTypes={'Expats'},YEARID = {$(=YearVariable)}>} Headcount) ,'#,##0;(#,##0)')

Now I want the stacked bar chart in which one bar show actual Emirati and expats values and the other bar show Budget values of emirati and expacts

Attached is the pic how graph should look like

Re: Stacked chart problem

Anonymous — Sun, 17 May 2015 14:57:27 GMT

I recommend to remove HCScenrio and HCTypes from the expressions completely, and use these fields as dimensions. It will be easy after that to get a stacked bar chart.

topic Stacked chart problem in QlikView

Stacked chart problem

Re: Stacked chart problem