topic Chart Recommendation - Combo Chart in App Development

Chart Recommendation - Combo Chart

tomf122 — Wed, 13 Jul 2022 13:28:05 GMT

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.

Re: Chart Recommendation - Combo Chart

justISO — Wed, 13 Jul 2022 13:49:09 GMT

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.

Re: Chart Recommendation - Combo Chart

tomf122 — Wed, 13 Jul 2022 14:14:56 GMT

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.

Re: Chart Recommendation - Combo Chart

Vishal_Gupta — Tue, 08 Nov 2022 20:44:19 GMT

@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