Chart Recommendation - Combo Chart

[tomf122]

I am trying to automate some charts which were once populated in excel. I have come across a combo chart in excel which is a mixture of a bar and scatter chart and after some research I don't believe it is possible to recreate in Qlicksense. Just wondering if anyone would know the next best chart which could replicate it or even two charts which would show a similar data structure. For my data I want to plot one material with up to 32 data values which I know may cause an issue as some charts have limits of the amount of values you can hold. Any guidance is much appreciated.   

[justISO]

Hi, maybe QlikSense 'Distribution plot' could be used? As Point you define your y axis [y] dimension, X-axis as [x] dimension, Y-axis measure you can make avg([y]). In 'Presentation' menu change the look from Horizontal to Vertical and 'Show' 'points only'. Color 'by dimension'. And it should look similar to your excel graph.

[tomf122]

Thanks for the suggestion, I have tried the distribution plot and it looks good but it only lets me place one value at a time on it. Is it possible to stack values on the Y axis or does it only deal with one value at a time.

[Vishal_Gupta]

@tomf122 you can try line chart to get such a visual.

You can get a result like this

In above example I have used

Dimension 1 - 'Distributor'

Dimension 2 - 'Title'

Measure - Any measure you can take

Change orientation and play with properties setting to achieve desired result