Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
soniasweety
Valued Contributor III

two in single bar

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

Tags (2)
14 Replies
Highlighted
arulsettu
Honored Contributor III

Re: two in single bar

can you post sample and expected output

ogster1974
Honored Contributor II

Re: two in single bar

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
Honored Contributor II

Re: two in single bar

you can also use Dual Function

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

HTH

Sushil

surendraj
Valued Contributor

Re: two in single bar

you can do this by combo-chart

1.avg(sales) as bar representatio

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

Capture.PNG

Result-->

Capture1.PNG

soniasweety
Valued Contributor III

Re: two in single bar

thanks

I need in qliskense

avg.PNG

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
Valued Contributor III

Re: two in single bar

not working

soniasweety
Valued Contributor III

Re: two in single bar

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

ogster1974
Honored Contributor II

Re: two in single bar

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
Honored Contributor II

Re: two in single bar

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