Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
soniasweety
Master
Master

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

14 Replies
arulsettu
Master III
Master III

can you post sample and expected output

ogster1974
Partner - Master II
Partner - Master II

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
Master II
Master II

you can also use Dual Function

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

HTH

Sushil

surendraj
Specialist
Specialist

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
Master
Master
Author

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
Master
Master
Author

not working

soniasweety
Master
Master
Author

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

ogster1974
Partner - Master II
Partner - Master II

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
Partner - Master II
Partner - Master II

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