Label on Grid charts

[#1]

Hoping someone here can help; I have a Grid chart as shown on the attached screenshot, and I want to show the value on the bubbles. I know that by default Qlikview doesn't support "Value on Datapoints" in the Expression level, so I added the following "dual(aggr(SubjectScore,Institution,Subject),Subject)" as a third dimension and enabled "Label on Datapoints" under Presentation. Depending on my selection in the Institution, this seems to work sometimes. If I narrow my selection of the Institutions, the values displayed on the datapoints are correct, but when I widen my institution selections, the values displayed on the datapoints are incorrect, sometimes even missing the labels for some data points. The weird thing about this is that when I move my mouse over to the dots, I can see that dual(aggr(SubjectScore,Institution,Subject),Subject) is calculating the correct value on the pop up labels 100% of the time. For some reason the labels on the datapoints are inconsistent with the value shown on Pop-up labels. Would greatly appreciate if someone can help on this issue as I've spent hours trying to figure this out!

Dimension 1: =If(Len(if(Aggr(Max(Ranking_lower),Institution)>=vMinRank and Aggr(Min(Ranking_lower),Institution)<=vMaxRank,Institution)) > 20, Left(if(Aggr(Max(Ranking_lower),Institution)>=vMinRank and Aggr(Min(Ranking_lower),Institution)<=vMaxRank,Institution),FindOneOf(if(Aggr(Max(Ranking_lower),Institution)>=vMinRank and Aggr(Min(Ranking_lower),Institution)<=vMaxRank,Institution),' ',5)-1) & Chr(13) & Mid(if(Aggr(Max(Ranking_lower),Institution)>=vMinRank and Aggr(Min(Ranking_lower),Institution)<=vMaxRank,Institution),FindOneOf(if(Aggr(Max(Ranking_lower),Institution)>=vMinRank and Aggr(Min(Ranking_lower),Institution)<=vMaxRank,Institution),' ',5)+1))

Dimension 2: Subject

Dimension 3:

=dual(aggr(SubjectScore,Institution,Subject),Subject)

Expression: SubjectScore

[Anil_Babu_Samineni]

When you say, If you are using widen the Institute does this value changed from your original report. Can you show image how data points are looking like before and after widen the field?

[#3]

See the value of "The Hong Kong Polytechnic University", for subject "Engineering & Technology". The correct value should be 81.1.

When I keep my selection of Institutions limited, the correct value is shown:

When I remove my selection on institutions (taking all institutions), the value displayed on the data points becomes incorrect; "The Hong Kong Polytechnic University", for subject "Engineering & Technology" now becomes 79.1, while I'm still keeping all other selections the same.

But when I mouse over the dot, the value is still correct: dual(aggr(SubjectScore,Institution,Subject),Subject) = 81.1, even though the label is wrong.

[Kushal_Chawda]

Would you be able to share the sample file?

[Anil_Babu_Samineni]

Hahaha, will you able to provide sample. The last screen shot is may help us to explain. Seems weird behavior going on

[#6]

Have been playing with this for hours and have not been able to fix it. I'm hoping someone would be able to help me solve it by having a look at my dimensions / expressions to see if you can pick up any mistakes?

[Anil_Babu_Samineni]

That's how we have to. And that we are not experts like you. If you provide Mock application we may able to offer you much better.

My concern is when Pop-Up is coming up in right manner it should come up in UI also.

One funny question - Does this Pop-Up and UI expressions are with in single expression?

[thomaslg_wq]

Hi Vincent,

Your dimension 1 is =If(Len(if(Aggr(...

When you create your dimension 3, you try to create the same result as your objet expression by dimension1 and dimension2 but you are not using the same dimension as dimension1, you are using the field [Institution]

How can you expect the same result without the same inputs ?

[#9]

I added those to add a line break to the axis labels, and also to filter the institutions according to the range that the user selects. I tried copy Dimension 1 (=If(Len(if(Aggr(...) into Dimension 3: dual(aggr(SubjectScore,Institution,Subject),Subject)

so it becomes:

dual(aggr(SubjectScore,If(Len(if(Aggr(...,Subject),Subject)

but the chart wouldn't render at all...

[#10]

Thomas, I think your response makes sense, I change dimension 1 to "Institution" and the labels are rendering the correct score. However, is there anyway I can keep my dimension 1 as:,If(Len(if(Aggr(...