Bar in table chart

[felcar2013]

hi

is it possible to get exactly the box below in qlikview? i think with the mini-chart option

the KPI can be any number or indicator, the +/-% a change from this point to a previous period. I think that should be possible, but as pivot table? not as table diagram, right?

what i do not how to do, is how to place the bar chart there? It shall be green if it is positive and red if it is negative (the +/-% field)

Is it possible to put the bar in the first row? and then the title? any help will be very welcome

felipe

[felcar2013]

if the bar were below the title, only one table diagram would be appropriate with mini-chart, what do you think?

[phaneendra_kunc]

If below chart fits your need...Grab it from the QV example that comes with the installation.

Look for Data visualizations.qvw --> Tables sheet.

Modified little bit to fit your need. Converted staright table to Pivot

[felcar2013]

thanks, i never saw the examples, seems to be what i am looking for, lets see how it goes

[sujeetsingh]

Pivot table offers about all the column to be represented as Gauge or chart

[felcar2013]

Hi, how can you get the -8.38% represented on the left side? i tried using the chart configuration option, but i cannot. there is a "colomix wizard" where i think i could do it, but i do not have it in my qlikview, it is version 11.2 Do you know if i have to installed it? according to the manual, it shall be under "File/Edit Expression dialog", but i do not see it. Is there any other way to get this?

or how can you get the bar to the left. It shall go to the left, as it it negative., many thanks

[phaneendra_kunc]

Look in Presentation tab --> Alignment (Right top corner).

Click on each expression and align as you need.

[felcar2013]

the problem is more to adjust the bar to the formula. If the -/+ % is positive, the bar shall be green and go to the right on that percentage. In this case the bar is negative -8.38%, so the bar shall be red, and shall be display on the left side (would that be possible?), at -8.38% of a total scale of 100%

Best

Felipe

[felcar2013]

do you know how can i deal with negative values? i got only one segment which changes to green if the value is positve but i cannot get the negative value within one segement

[Gysbert_Wassenaar]

That's not possible. You can fake it somewhat by manipulating the gauge color and the expression background color. See attached example.