Mini Chart Bug?? Help please

[#1]

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!

[disqr_rm]

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.

[#3]

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?

[#4]

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

[disqr_rm]

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

Possible that you could attach a sample data file here?

[#6]

[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

[#7]

The scrip

[#8]

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$])

;

[disqr_rm]

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

[#10]

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.