topic Mini Chart Bug?? Help please in QlikView

Mini Chart Bug?? Help please

Fri, 28 May 2010 20:53:43 GMT

I have a straight table, using 2 dimensions and a simple expression SUM(Value) shown as a mini chart month by month

Everything seems fine until i look closely, for some reason, one of the mini charts contains 3 lines, one for it's row, and one for each of the 2 below it... Bizzarre!?

Has anyone else come accross this, is it something i've done? I've started from scratch only bringing in the 4 fields i need into a single table just in case anything else was causing it and have got the same result.

Also, when i produce the same soft of thing in a pivot table, it looks fine. But i dont want a pivot table, i want the mini chart 😞

Here's a picture of what's going wrong, look at row 4.

Very strange.

HELP!

Mini Chart Bug?? Help please

disqr_rm — Fri, 28 May 2010 21:52:54 GMT

Either put Sector with Total under Sum or move Type to expressions as only(Type).

SUM(TOTAL <Sector> Value)

The problem is it's trying to use both dimensions to plot your chart.

Mini Chart Bug?? Help please

Fri, 28 May 2010 22:24:16 GMT

Thanks Mukesh,

I've tried both of the above, when i do the first I get - to get this i changed my expression to SUM(TOTAL <Sector> Value) and removed Sector from the dimensions:

When i do the second, i get - to do this i left the original extression alone, added a new one of Only(Type) and removed Type from the dinensions:

I'm obviously doing something wrong, and not quite understanding what you mean, ideally i want a line for each sector and each type within that sector, with a month on month mini chart on each line.

Can you advise any further?

Mini Chart Bug?? Help please

Fri, 28 May 2010 22:29:20 GMT

Apologies, i meant Rakesh... it's been a long day!

Mini Chart Bug?? Help please

disqr_rm — Fri, 28 May 2010 23:04:07 GMT

Oh! I see. You got multiple Types within one Sector.

Possible that you could attach a sample data file here?

Mini Chart Bug?? Help please

Fri, 28 May 2010 23:24:11 GMT

[View:http://community.qlik.com/cfs-file.ashx/__key/CommunityServer.Discussions.Components.Files/11/7510.Test.xls:550:0]

Here's the data, not sure if ive attached it correctly, tried to add my qvw file but it says that file can't be inserted?

Thanks for your help

Mini Chart Bug?? Help please

Fri, 28 May 2010 23:26:35 GMT

The scrip

Mini Chart Bug?? Help please

Fri, 28 May 2010 23:27:39 GMT

The script i use to load it is very simply:

Directory;

LOAD

Sector

[Opportunity Type]

as Type

MonthName

([Anticipated Close Date]) as Month

Value

FROM

[Test.xls]

(

biff, embedded labels, table is [Test$])

;

Mini Chart Bug?? Help please

disqr_rm — Sat, 29 May 2010 00:58:21 GMT

Very strange! May be a bug somewhere.

Anyway, enclosed is a workaround, if that works for you. I will dig more and get back to you if I find anything better.

Hope this helps you.

Rakesh

Mini Chart Bug?? Help please

Sat, 29 May 2010 09:26:19 GMT

Thanks Rakesh, yes it is strange, because effectively whats in the workaround should be what the table with 2 dimensions should do in the first place (do you agree?). If you get any further with it let me know. In the meantime i will log a support call.

Mini Chart Bug?? Help please

Sat, 29 May 2010 09:37:17 GMT

Actually, if you leave the concatenated dimension in (hide the column) then add the two original dimensions back, it works perfectly! Still seems odd that it didnt in the first place.