topic Re: Bar in table chart in QlikView

Bar in table chart

felcar2013 — Thu, 21 Feb 2013 15:12:35 GMT

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

Re: Bar in table chart

felcar2013 — Thu, 21 Feb 2013 17:24:01 GMT

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

Re: Bar in table chart

phaneendra_kunc — Thu, 21 Feb 2013 18:37:24 GMT

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

Re: Bar in table chart

felcar2013 — Fri, 22 Feb 2013 08:43:56 GMT

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

Re: Bar in table chart

sujeetsingh — Fri, 22 Feb 2013 09:01:44 GMT

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

Re: Bar in table chart

felcar2013 — Fri, 22 Feb 2013 14:27:55 GMT

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

Re: Bar in table chart

phaneendra_kunc — Fri, 22 Feb 2013 20:27:30 GMT

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

Click on each expression and align as you need.

Re: Bar in table chart

felcar2013 — Wed, 27 Feb 2013 14:00:56 GMT

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

Re: Bar in table chart

felcar2013 — Fri, 01 Mar 2013 13:33:28 GMT

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

Re: Bar in table chart

Gysbert_Wassenaar — Fri, 01 Mar 2013 14:52:53 GMT

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

Re: Bar in table chart

felcar2013 — Fri, 01 Mar 2013 20:57:02 GMT

many thanks

nice solution, but i would need two boxes for the same KPI? we tried to put text boxes over a bar chart and got what is in the figure. the difficulty is when moving the KPI boxes, but visually it contains what we wanted

i think it is not sustainable in the long term

thanks for your help again

Re: Bar in table chart

Anonymous — Mon, 21 Nov 2016 15:04:14 GMT

Hi Gysbert,

How you can add a dimension with the ValueList.

Example Negative/Positive bar by Country.

Thank you

Re: Bar in table chart

felcar2013 — Tue, 22 Nov 2016 10:56:50 GMT

Hi,

go please in your Chart to dimensions, then click on "Add Calculated Dimensions" and type in the function ..

ValueList('value1,'value2') and thats it

in your Expression you can refer to the value list Dimension, say, if(ValueList('value1','value2')=value1, 'do something','else')