topic Combine dynamic en static data in QV object (line chart) in QlikView

Combine dynamic en static data in QV object (line chart)

Fri, 30 May 2014 12:12:38 GMT

I want to supplement an object (line chart) with static data, with static data of before 2013. Is this possible? The expression that I use is (with data for 2013):

(sum (A Costs) + sum (Costs B))

(sum (TOTAL Costs B) + sum (TOTAL Costs))

This results is a line chart (in %) of various objects (hardware, software, staff, and other). Of 2012 and before that I only have static data in %. How can I combine the two?

	Hardware	Software	Staf	Other
2005	19%	33%	30%	18%
2006	17%	34%	32%	17%
2007	15%	34%	34%	17%
2008	17%	35%	31%	18%
2009	16%	35%	32%	17%
2010	13%	37%	30%	19%
2011	13%	35%	31%	21%
2012	10%	40%	29%	21%

Re: Combine dynamic en static data in QV object (line chart)

Fri, 30 May 2014 12:17:43 GMT

Wilfred,

You could load both sets of data into different tables, and create 2 different expressions for the chart

The first one for the historical data would run to 2013, and the second expression would continue from 2014.

If this does not help - can you post an example?

Richard

Re: Combine dynamic en static data in QV object (line chart)

Fri, 30 May 2014 12:20:55 GMT

For your second set of data, covering data 2012 and earlier, try this:

Dimension: Object (Hardware, Software, Staf, Other)

Expression: avg(static percentage)

Re: Combine dynamic en static data in QV object (line chart)

Fri, 30 May 2014 12:30:13 GMT

I am preparing an example for you.

Re: Re: Combine dynamic en static data in QV object (line chart)

Fri, 30 May 2014 12:36:09 GMT

Here you go.

You should be able to convert for your own data.

The chart is tidied up by

You can see how the 2 expressions merge, if you alter the colours to same, and disable labels. (Chart properties-> expressions ->expressions as legend - uncheck )

Hope this helped.

Richard

Re: Combine dynamic en static data in QV object (line chart)

Sun, 01 Jun 2014 12:42:37 GMT

Thanks, this is successful (but not entirely to how I want it). I just want to use multiple components (hardware, etc), where now only 'Percentage' is being used. I would like to use hardware, software, and other staff. such as:

table: LOAD * INLINE [

Year, Hardware, Software, Staff, Other

2004, 0.3, 0.2, 0.4, 0.1

2005, 0.3, 0.2, 0.4, 0.1

2006, 0.3, 0.2, 0.4, 0.1

2007, 0.3, 0.2, 0.4, 0.1

2008, 0.3, 0.2, 0.4, 0.1

2009, 0.3, 0.2, 0.4, 0.1

2010, 0.3, 0.2, 0.4, 0.1

2011, 0.3, 0.2, 0.4, 0.1

2012, 0.3, 0.2, 0.4, 0.1

];

This is unfortunately not as it should be. See the example I've added when the components of hardware, software, personnel and other are added and also the added component 'Only(Hardware)' isn't working correct.

Important! I use the dimension 'ICT component' for the use of:

(sum (A Costs) + sum (Costs B))

(sum (TOTAL Costs B) + sum (TOTAL Costs))