Error in Set Analysis

[#1]

Hello Everybody,

I have used set analysis in my expression for chart.

round(sum({$<WeightedUnweighted.= {'Weighted'},[Probability Group.]={'Open'},Year.= >}RevPreAmount.)/1000000,'0.01')

I am getting an error message when hovering over any of the bar charts.

Is there anything wrong in the expression.

Please find the attached screenshot for the same.

Thanks In Advance

Sonali

[#2]

Hi Alan,

Yes, the text object is returning the correct result without any error.

[Anonymous]

Hi sonali,

Did u try the above Solution???

[#4]

HI Karthigayan,

I tried it this. This is also giving me the same error message.

[kuba_michalik · Accepted solution]

You could just input some static label for the dimension on the Dimensions tab of chart properties. It seems QV trying to use that calculated dimension formula as the label is the only problem, after all the dimension values themselves on that axis seem fine.

[Anonymous]

Are you using any calculated dimensions? If the expression correctly evaluates outside the chart, there is likely something else at play here that is causing you pain.

Try temporarily disabling this expression and putting in something simple. Does it work?

[#7]

Thanks Jakub.

Thank you for your help. It's working now.