topic Re: How to fix this Bar chart with Line axis? in QlikView

How to fix this Bar chart with Line axis?

bhaveshp90 — Wed, 25 Nov 2020 16:16:04 GMT

Hello,

I am having this visual which represents the Profit Percentage range vs the Sales Amount for the projects.

But the Sales amount is summing up all the project no's and not showing as a line axis.

Can you please tell me what should I need to fix here?

thanks

Bhavesh

Re: How to fix this Bar chart with Line axis?

vamsee — Tue, 04 Sep 2018 15:41:24 GMT

May be add Project No as Dimension.

Your dimension says 'GM_Per_Bucket'

Re: How to fix this Bar chart with Line axis?

bhaveshp90 — Tue, 04 Sep 2018 15:45:15 GMT

Hi,

I have already added another expression which counts the project count as given below;

=count({<Report_Param ={'Gross Profit in % of Sales'}, Header_2= {'Budget'}, Header_1= {'Upd.OEC'}>}Project_Number)

Re: How to fix this Bar chart with Line axis?

vamsee — Tue, 04 Sep 2018 18:01:54 GMT

A chart aggregates all its expressions to the dimension. As you do not have a dimension for Project, the chart aggregates the data to the dimension (GM_Per_Bucket).

If you want to use multiple dimensions use

https://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/ChartFunctions/aggr.htm

Also, please have a look at the following

Dimensions and Measures