Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
cristian_av
Creator III
Creator III

Static Values of Dimension in Chart

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!!

borrar.png

1 Solution

Accepted Solutions
swuehl
MVP
MVP

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)

View solution in original post

4 Replies
swuehl
MVP
MVP

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
Creator III
Creator III

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
Creator III
Creator III
Author

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

maxgro
MVP
MVP

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

Redmond Debt Profile Chart.qvw | Qlik Community

1.png