topic Re: Combo Chart - Line to Match x-axis data in QlikView

Combo Chart - Line to Match x-axis data

craig157 — Sat, 16 Nov 2024 01:19:10 GMT

Hi All,

Looking for some help on getting my Line Dimension to Match to the X-Axis Type that I am using.

Essentially it looks like the first picture but I want it to be more like the second picture.

I just want to count how many items are in each of these dimensions, for example:

A3 - 6,000 Devices

A4 - 1,000 Devices

A5 - 4 Devices

etc.

Unfortunately it currently is only taking into regards the Month Dimension from the Y-Axis Dimensions.

Any ideas?

Current Chart

Proposed Chart

Re: Combo Chart - Line to Match x-axis data

Brett_Bleess — Thu, 05 Mar 2020 19:38:28 GMT

Likely going to need a sample QVW file to dig into this one, little difficult to ponder what may be going on from just the screenshots you provided, so if you still require assistance, it would be best if you can attach a small app or a reduced version of this one to let folks have a look at the underlying chart setup etc. and your data model.

Regards,
Brett

Re: Combo Chart - Line to Match x-axis data

johnca — Fri, 06 Mar 2020 16:19:15 GMT

I would suggest creating two charts, one a stacked bar and the other a line, and overlaying one with the other keeping the time dimension the same. You may need to tweak the X and Y-axis expressions to insure the timeline matches. Then, make one invisible.

HTH,

John