Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I want to convert my chart expression into field value. How can I plot field value as chart expression ?
For eg:
I've data in the below format
LOAD
* INLINE
[
Val
10
20
30
]
;
LOAD
* INLINE
[
Dim1, Expression
G1, Min(Val)
G2, Max(Val)
]
;
- Now in straight table I'll add Dimension as Dim1.
- In expression I need the expression what we had for each dimension value.
G1 - Min(Val)
G2- Max(Val)
- I know that we can put if condition in expression tab as =If(Dim1 ='G1',Min(Val),Max(Val)), but I don't want to control in expression tab. I want to control using field value i.e. the value of field will be expression.
How can I do this.
Thanks,
Jagan
Like this ?
Hi,
Try this
Regards,
Jagan.
But Min and Max value is giving wrong answer
Hi
Use Dim1 as the chart dimension and $(=Expression) for the chart expression.
HTH
Jonathan
I had used this exp right now
= Pick(Rno,Min(Val),Max(Val))
It is working, but how to control using field value.
Jonatham - I already tried it but no use.
Hi Jagan,
try this approach:
Let me know.
Best Regards
Andrea