Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Any ideas? I think I'm going around in circles.
Check out the attached as an example (QV11 only) using a control table to select which columns to show. Focus less on the data and more on how I accomplished the dynamic columnns.
Thanks Isiah. This works like a charm.
Hi Phani,
I like your solution.
Is there a way to use an expression like this in the script editor, when you create the inline table:
=Avg({$<Institution= p(Institution2) >} [Actual value])
I tried this :
Metric:
replace LOAD recno() as MetricSequence,* INLINE [
Metric, Expression
Average, "AVG({$<Institution={'*'}>}[Actual value])"
"Peer Group", "Avg({$<Institution= p(Institution2) >} [Actual value])"
];
but it give an error, probably because of the symbols.
Is it possible to have an expression like this in the inline table?
Thanks
Yes you can write these type of expressions, but not in inline statements.
1.) you can load it from Excel
2.) if you are not using reduce and Reload concept, you can write it in the Grid it self.
a) Edit script
Metric table:
LOAD * INLINE [
Metric, SeqID
Average ,1
Peer Group,2
];
b.) Front end:
Write below this as your expression
pick(SeqID,AVG({$<Institution={'*'}>}[Actual value]),Avg({$<Institution= p(Institution2) >} [Actual value]))
c.) Add Metric as Dimension
d.) Also add Metic as Selector (list box or Multi Box)
Thanks,
Phani
Yes you can write these type of expressions, but not in inline statements.
1.) you can load it from Excel
2.) if you are not using reduce and Reload concept, you can write it in the Grid it self.
a) Edit script
Metric table:
LOAD * INLINE [
Metric, SeqID
Average ,1
Peer Group,2
];
b.) Front end:
Write below this as your expression
pick(SeqID,AVG({$<Institution={'*'}>}[Actual value]),Avg({$<Institution= p(Institution2) >} [Actual value]))
c.) Add Metric as Dimension
d.) Also add Metic as Selector (list box or Multi Box)
Thanks,
Phani
This is a really great example - thanks!!