topic Re: Label on Grid charts in QlikView

Label on Grid charts

Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Label on Grid charts

Anil_Babu_Samineni — Thu, 15 Jun 2017 06:44:23 GMT

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?

Re: Label on Grid charts

Thu, 15 Jun 2017 07:08:22 GMT

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.

Re: Label on Grid charts

Kushal_Chawda — Thu, 15 Jun 2017 07:17:06 GMT

Would you be able to share the sample file?

Re: Label on Grid charts

Anil_Babu_Samineni — Thu, 15 Jun 2017 07:23:46 GMT

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

Re: Label on Grid charts

Thu, 15 Jun 2017 07:28:29 GMT

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?

Re: Label on Grid charts

Anil_Babu_Samineni — Thu, 15 Jun 2017 07:33:12 GMT

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?

Re: Label on Grid charts

thomaslg_wq — Thu, 15 Jun 2017 07:33:18 GMT

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 ?

Re: Label on Grid charts

Thu, 15 Jun 2017 07:42:56 GMT

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...

Re: Label on Grid charts

Thu, 15 Jun 2017 07:45:13 GMT

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(...

Re: Label on Grid charts

thomaslg_wq — Thu, 15 Jun 2017 07:53:45 GMT

Well,

What is the reason of this If(Len(if(Aggr(... ?

I see string functions : so you may use these in script.

I see if functions with vMinRank etc. : so you may use set analysis expressions. As sum({<DimensionToFilterOnFollowingCondition={"=OtherMeasure>ValueInVariable"}>}MeasureField)

But I am not sure it will be anough

Re: Label on Grid charts

Thu, 15 Jun 2017 07:58:25 GMT

I have a slider object top right to allow users to refine the list of institutions based on their overall rank.

The reason I used the If... for Dimension 1 is to keep that filtering, and also to add a new line character to the X-axis labels

Re: Label on Grid charts

thomaslg_wq — Thu, 15 Jun 2017 08:13:52 GMT

let's do it step by step, (we should not worry about the string functions for now)

First, filter on [Institution] with a set analysis expression :

dim1 = [Institution] (no left and len functions for now)

dim2 = [Subject}

dim3 = dual(aggr(SeeMeasure,Institution,Subject),Subject)

Measure = assuming it was ==> sum(Measure)

It should now be ==> sum({<Institution={"=Max(Ranking_lower)>=vMinRank"}>*<Institution={"=Min(Ranking_lower)<=vMaxRank"}>}Measure)

Re: Label on Grid charts

Sun, 18 Jun 2017 13:20:59 GMT

Hi Thomas, I did exactly as you suggested and find that if I change the vMinRank and vMaxRank with the slider, it still messes up the data labels.

Re: Label on Grid charts

Sun, 18 Jun 2017 13:22:15 GMT

Is there anyway I can use the dual(aggr(SubjectScore,Institution,Subject),Subject) method for labeling while Dimension 1 and Dimension 2 are calculated dimensions?

Re: Label on Grid charts

thomaslg_wq — Sun, 18 Jun 2017 14:23:34 GMT

Hi Vincent,

I lack of ideas...

What happens whith the Dim3 as =text(Non-aggr-measure) ?

Could you please copy/paste all dimensions and expressions to be sure ?

And maybe if you can share some sample data/data model ?

I could try something later today or tomorrow.

Re: Label on Grid charts

vvira1316 — Tue, 11 Jul 2017 14:48:43 GMT

Hi Vincent,

I'm developing Grid Chart for my requirement wondering how you were able to get angled labels for the institution? If you will guide or provide input on it will be great help.

Thanks,

Vijay

Re: Label on Grid charts

vvira1316 — Tue, 11 Jul 2017 17:40:16 GMT

Hi Vincent,

I figured it out. I had to switch to bar chart to access dimension axis properties and then switch it to grid chart and it retains settings.

Thanks,

Vijay

Re: Label on Grid charts

rammuthiah — Tue, 23 Jan 2018 12:07:11 GMT

Is this possible to get values in Qlik Sense Grid Chart Extension?