Static Values of Dimension in Chart

[cristian_av]

Hi

I need to do a graph with static dimensions on a graph. i.e. In the image,

a) I have a lot more dimensions, but I need to show only "Manzanas, Cerezas, Arandanos...."

¿Is it possible?

b) For the same graph, is it possible to mix the "graph" with a table as shown? Or something Similar?

Thanks!!

[swuehl · Accepted solution]

You can look into using the mini chart display option to add e.g. bars to a straight table with numbers:

Mini Bar Chart inside Straight Table and in List Box

You can limit your dimension either using a calculated dimension:

=If(Match(DimensionField, 'manzanas','cerezas'), DimensionField)

or using set analysis in all your aggregations:

=Sum({<DimensionField = { 'manzanas','cerezas'}>} Value)

[girirajsinh]

for static value list you can use Valuelist() Function.

You can load image by Bundle load

like

or

for straight table

set Representation as Image

[cristian_av]

Thanks! Do you know if is it possible to set multi-colors to mini graphs?

[maxgro]

Another example (you can also find the .qvw) here

Redmond Debt Profile Chart.qvw | Qlik Community