Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Everyone,
I currently have a straight table with a series of mini-charts displaying data, however I was wondering if it were possible to store a column name as a variable on a mouse click even if it is an expression in the chart. I am hoping to use the variable to display a dynamic chart across all my customers based on the selected metric.
Please let me know if you need clarification and thanks in advance for your help.
Hi,
Use Getfieldselections( ) command to fetch the field.
HTH
Regards
Anand
Hi,
i hope this little example help u if this is that u are looking for
C u,
Stefano
Hi,
See the attached sample file you may be use some thing like this
Data:
LOAD * INLINE [
ColA, ColB, ColC
A, 145, 14
B, 125, 23
C, 242, 85
];
Rotate:
LOAD * INLINE
[
Field
ColB
ColC
];
HTH
Regards
Anand
Hi,
Store selection value into variable like
vTest = Getfieldselections( Field )
and get this value in expression and calculate
= Sum( $ ( vTest ) )
and use a load with
Data:
LOAD * INLINE
[
ColA, ColB, ColC
A, 145, 14
B, 125, 23
C, 242, 85
];
Rotate:
LOAD * INLINE
[
Field
ColB
ColC
];
See the attached
HTH
Regards
Anand
Hi,
You got correct answer with this solution.
Regards,
Anand
Hi everyone,
Thank you for the replies. I guess to more succinctly explain my problem: I have a straight table and I would like a variable trigger (or its equivalent) on selecting an expression value (or it's header) within the table. Is this possible? I know it is possible with a field, but what about with an expression or header?
Thanks,
Uller
If I understand u can use "Group option" in the tab expression of the table.
So u can switch beetwen your expressions by clicking on the icon in the table...
Stefano.
Hi,
Please see if the attached sample can help you.
Cheers.