We are in the process of migrating from QV8.5 to QV10 SR2. I have come across the Expression Default issue in my testing.
I am having another issue where I cannot get an expression in a bar chart to use the Number Format Setting I select in the chart's Number tab. No matter what I select, the value shows (ie. Number on Data Point) with a large number of decimals and no '%'. The settings Number and Show in Percent are selected. In version 8.5, it works fine. This is a complicated chart with 4 calculated dimensions. I cannot seem to duplicate the issue in a simple chart.
Do you know of any QV10 SR2 bugs that may be causing this issue?
I was able to create a sample application to demonstrate the issue I am having.
The problem seems to occur if expression labels are used in expressions to calculate values. In the attached application, the charts on the left calculate Calc Value using dimensions. In the charts on the right, Calc Value is calculated using two expression labels. The results should be the same, but I am only able to change the Calc Value Number Format Setting on the bar chart on the left. Any changes I make to the Number Format Setting on the chart on the right are ignored.
I'm still getting used to the new website design. I couldn't seem to add an attachment by replying to your previous post. I had to edit my previous post and add it (not sure if you get notified when that happens).
Please see my previous post for a sample application demonstrating the issue.
This is because all three expressions are enabled. If you disable the first two it shows percentage of the third correctly. I think it's a bug. It seems not to be able to display the right number format of the third and only bar.
I wouldn't use a chart in this way. Because the two expression are only showed on hovering the thrid expressions bar. So you never would see those values at a glance and on printouts.
I also do not understand why you have the figures (Qty, Price) as dimensions?
Also, if you have dimensionality you have to use an aggregation function (at least a sum).
See my version as a suggestion.
Data & AI Engineer at Orionbelt.ai - a GenAI Semantic Layer Venture, Inventor of Astrato Engine
This application was just one I created quickly to illustrate the issue. There is no reason to have Qty and Price as dimensions.
If I disable the first two expressions, the third one will not work as it requires the first two. The expressions in the actual production application are much more complicated than in this example. I guessing this is why the original developer used this technique.
you could always build expressions that not refer to other expressions. I tend to not reuse expressions in other expressions. I think there are also a lot of limitations with it. I don't know if functions like aggr would work like expected...
- Ralf
Data & AI Engineer at Orionbelt.ai - a GenAI Semantic Layer Venture, Inventor of Astrato Engine
just let "calc value" your first expression - you will face similar problems with stacked layouts and splitting axes and with 3 dimensions you have an implicit stacked layout - I'm not sure if it's a bug since the first calculated expression dictates the axis (only a rule - not true at all) - but let us know, if you have an answer.
Sven, you are correct, I can make 'Calc Value' my first expression and this will allow me to control the number format. It will also work in my production application as I only show a bar for one of my expressions. However, if I have multiple expressions that I want to show on a stacked bar and the user wants to be able to switch to a straight table, I do not want to have to move one of the expressions to the top and changed the display order.
When I spoke to support, I explained that this is an issue that was working fine in QV8.5 and is no longer working in QV10. Bug ID 38990 has been submitted to the QA department.
Thank you both for you input and help with this issue.
