I added a statusbox and you are right - I click on the field "plant" (selfmade) in one line, but at the same time, the ID of the forklift in that line is selected, so I see only that one.
I am at a loss at why that could be. I haven't designed it that way. It must be a side_effect of something I've done.
Similarly, when I set the chart to 'read_only' and instead add a listbox for that selection and select the plant "56" in that, I see only part of the lines with that plant.
What is to be done there?
very strange: I just re-did that calculation in a listbox_object and when I ignore the field "plant" in one of the lists and only include the area from the other one - which, however, is the "master_list" where all our forklifts are enumerated - it looks much better. I can now select in the chart itself and I see much more - probably all there is though I must check.
It seems to be working now - but can you explain why it wasn't working before?
Your suggestion makes sense - but apparently that was not the reason as I just have a front_end calculation now ...
P.S.: Oh no - one should always look closely - it works, but only from my listbox_object. When I select in the chart itself, I have the same issue as before - the ID is selected simultaneously and I only see that one line.
Hi, if I understant it right, you have a line chart with different lines for the same plant, so there should be a dimension telling QV to set different lines and seems that dimension is related to the ID of the forklift, if this is the case, the selections made are the normal behaviour, because you are telling QV to select values related to that particular line.
If you want a filter that affects goups of lines I think you need to set that filter in a different object outside the chart.
I would say that the selection in this case goes only on these records on which these particulary calculations is made and not on the calculation-value itself. I think you could it only solve if you made these calculation within the script and could then directly select a field-value.
How about a mapping in your script?
Using mapsubstring to convert the 56 to 5.6 combined with an if statement for area's where no 56 is found.
You could add more than one value of course in the mapping:
mapping Load * inline
IF(NOT(ISNULL(Werk)), '6.4', mapsubstring('area_map', Werk))