topic Chart Dimensions in QlikView

Chart Dimensions

Thu, 26 Nov 2009 17:17:41 GMT

Hi, first post on here so apologies if I have posted this in the wrong section. I currently have a bar chart which details 3 measures, being Line Efficiency, Labour Productivity and Labour Efficiency. The application is being used for Production Performance Measuring and is divided into various machines. I am therefore currently using the machine name as the dimension and then 3 expressions, 1 for each measurement required.

This provides me with a bar chart displaying the three machines seperately and then each expression as a measure as would be expected. I would like to be able to reverse this chart however and use each measure of performance as a dimension, and then display each machine side by side within each of these measures.

Any help with this would be greatly appreciated.

Thanks

Chart Dimensions

Thu, 26 Nov 2009 19:02:24 GMT

In this case you need to create only one expression,

You also need to create a field containing threee indicators such as 'Line efficiency'; 'Performance Measuring','Labour Efficiencey',eetc..

Then in your expression you must do something like IF(indicators = 'Line efficiency',sum(xxxx),0) ° IF(indicators = 'xxxxxx',sum(yyyyyy),0) etc...

Then you add the Indicators field as a dimension.

Rgds,

Sébastien

Chart Dimensions

vidyut — Thu, 26 Nov 2009 19:11:22 GMT

Interesting one 🙂

One simple solution would be like this. Say i have Machine Names(M) and Measures(M1,M2,M3).

I have loaded a Inline table with the data (Shown Below). For the chart that you want, Do the 'Turning around' using CrossTable, and then use the Measure and Machine as Dimensions., and Sum(Value) as Expression for your bar chart.

Create a Cross table

A:
CrossTable (Measure,Value)
Load * Inline [
M,M1,M2,M3
1,20,40,50
2,30,60,50
3,20,20,20
4,50,30,20
];

BarChart:

Dimensions: M,Measure

Expression: Sum(Value)

Chart Dimensions

Fri, 27 Nov 2009 03:11:49 GMT

I had not heard of Crosstable before ... pretty cool. Thanks Vidyut

Chart Dimensions

Fri, 27 Nov 2009 17:37:40 GMT

Hi, I have looked at this crosstable and it provides me with the correct layout. Can I however use formulae to calculate the relevant values as opose to static values and if so what would the script look like, sorry if this sounds stupid but am new to qlikview.

Thanks again.

Damien

Chart Dimensions

vidyut — Fri, 27 Nov 2009 19:25:43 GMT

In that case, go with the suggestion provided by spastor, That should work.

Chart Dimensions

Fri, 27 Nov 2009 19:32:09 GMT

Hi, am not sure how to go about implementing the solution provided by Spastor unfortunately. I know how to create an additional field but how do I add indicators to this.