chart properties

[#1]

How to get the two results/values in a single column in chart,

Normally min values will come in one column and max values will come in one column, but

I would like to get the min and max values in one cell. Like

Min,Max

How I will get like this? please help me.

[sivarajs]

Try to stack the bars

[#3]

Hi,

Try this

max(Value)&'-'&min(Value)

May be it will work

[PrashantSangle]

Hi,

Use concat()

or append result of two expression using &','&

for expamle

expr1&','&expr2

Regards

[hannan_t]

Try using the expression in the following way,

Sum(Max) &','& Sum(Min)

[#6]

if you do not have Min and Max values calculated in your load you will have to use aggr. something like:

Set Variable:

vMinSales = aggr(min(sales), ordernumber)

vMaxSales = aggr(max(sales), ordernumber)

and then use the following in your expression:

$(vMinSales ) & ',' & $(vMaxSales)

Hope that works for you.

Regards

RL

[#7]

Thank you Rahul