two in single bar

[soniasweety]

Hi all,

I have a bar chart  with one dimension and  two measures

dim:country

measures:1. count(country)

2. avg(sales)

if I  use this   am getting two bars   

but my requirement is    I want to show two in single bar  [but not stack]

because stack will show the accumulate values

-- avg(Sales)  it should show one bar  and on top I want to show only count(country)    not as bar  only count.

Thanks

Sony

[arulsettu]

can you post sample and expected output

[ogster1974]

So you want the data point to show the second measures value but display the first measure as a bar.  

The closest I could come to that requirement but be a combo chart.

Measure 1 displayed as a bar

Measure 2 displayed as a point

This would avoid the appearance of stacking

Regards

Andy

[sushil353]

you can also use Dual Function

Dual(Count(Country),avg(Sales))

HTH

Sushil

[surendraj]

you can do this by combo-chart

1.avg(sales) as bar representatio

2.count(sales) as values on data points.

Result-->

[soniasweety]

thanks

I need in qliskense

above image showing for two measures  

I need like      anyone of bar should show   with two results ---    93.19 ,100       the 100 I need only result on top of bar  not as separate bar or stack

[soniasweety]

not working

[soniasweety]

thanks andy,  but  I need only result I don't want to show any chart with bar /line

[ogster1974]

It would look ok if you applied that approach.  Its not a line or bar

You alot more custom control over chart objects in QlikView as is discribed down the thread.  if you wanted that kind of functionality you'd need to look at extensions so have a look on Qlik Branch.

Regards

Andy

[ogster1974]

could you offset your second mesure with the value of the first and then still stack it?