topic chart properties in QlikView

chart properties

Wed, 15 Oct 2014 06:44:40 GMT

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 — Wed, 15 Oct 2014 06:48:27 GMT

Try to stack the bars

Wed, 15 Oct 2014 06:51:11 GMT

Hi,

Try this

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

May be it will work

PrashantSangle — Wed, 15 Oct 2014 06:52:22 GMT

Hi,

Use concat()

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

for expamle

expr1&','&expr2

Regards

hannan_t — Wed, 15 Oct 2014 06:52:39 GMT

Try using the expression in the following way,

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

Wed, 15 Oct 2014 12:06:51 GMT

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

Thu, 16 Oct 2014 05:34:10 GMT

Thank you Rahul