topic Re: Line Chart with Label inside the plot area in QlikView

Line Chart with Label inside the plot area

Mon, 10 Mar 2014 08:23:06 GMT

Hi, I need to create a line chart with label inside (or on the left) in the plot area (please see attached picture).

1) How to disable the Y-axis number?

2) How to Label the line?

Regards

Benjamin See

Re: Line Chart with Label inside the plot area

stevedark — Mon, 10 Mar 2014 08:28:04 GMT

That looks like a job for a Mini Chart.

Create a chart of type Straight table with the dimension you want. Then create an Expression for the straight table. On the expression tab select Mini Chart from the Display \ Representation drop down. Once that has been done a button will appear with the legend Mini Chart Settings. In here you can set a dimension do show your chart over and various other options.

Good luck!

Steve

Re: Line Chart with Label inside the plot area

veidlburkhard — Mon, 10 Mar 2014 08:51:24 GMT

Hi Benjamin,

if it is this what you want

then wrap your expression into the dual function e.g. Dual(If(Month=Min(TOTAL Month), Country, ''), Sum(Sales))

Please check 'Values on Data Points' and you will get the above result.

Enjoy

Burkhard

Re: Line Chart with Label inside the plot area

Mon, 10 Mar 2014 08:53:30 GMT

I think what I need need is Mini Chart. Now testing on it. Thanks.

Re: Line Chart with Label inside the plot area

Mon, 10 Mar 2014 09:01:32 GMT

I try to put in 60 days (Date as Dimension) in Mini Chart, and I get below error message:

"Allocated Memory Exceed"

Is there any limitation of the Mini Chart? Currently I am using PE version.

Regards

Benjamin See

Re: Line Chart with Label inside the plot area

veidlburkhard — Mon, 10 Mar 2014 09:09:23 GMT

Sorry, Benjamin, I forgot to hide the axis. If you go to 'Axis' and mark the 'Hide Axis' check box this is the picture you'll get. Looks like mini charts...

Regards

Burkhard

Re: Line Chart with Label inside the plot area

stevedark — Mon, 10 Mar 2014 09:12:27 GMT

Hi Benjamin - there is not a limit on dimension values that I am aware of. How many rows does your straight table have?

Allocated memory exceeded can often come from an over complicated expressions (perhaps you could post the expression here?) or issues in the data model - eg. tables that don't join to each other causing Cartesian products.

Re: Line Chart with Label inside the plot area

Mon, 10 Mar 2014 09:15:30 GMT

Hi,

Yes, it was Mini Chart that I looking for.

Thanks. I got all I need.

Re: Line Chart with Label inside the plot area

Mon, 10 Mar 2014 09:18:05 GMT

Hi, thanks. I put the dimension field in the wrong place. It all working fine now.