Show values from excel

[#1]

Hi all.

This is probably a very simple question but I have come to a stop...

I have a excel where I have collect some goal values and would like do use them in combo charts.

Have tried with example only({$<GoalStation={"CoachDialog"}>} Value) but don't get the value 90%.

Atteched the excel.

Thanks!

[datanibbler]

Hi Björn,

looking at the Excel, "GoalStation" should naturally be your dimension, yes?

Why do you want to display the value for only one of those?

If you want to use the above as an expression to display, try with an IF_construct instead.

Your set_expression actually looks correct to me, but sometimes you just have to try out different aggregation_functions - or try single_upper_quotes instead of the double quotes.

HTH

Best regards,

DataNibbler

[#3]

Hi Björn Larsson,

I tried the same example and able to get the 90%. May be you might having selections made in the QVW, so that the value is not displaying because of $ in the expression. If you want to show the value irrespective of selection, use 1 instead of $. The below is the qvw i created for ref.

[hic]

This should work. What do you get if you skip the Set analysis and just make a simple pivot table with GoalStation and Year as dimensions and Avg(Value) as Expression?

HIC

[nizamsha]

PFA