How to fix this Bar chart with Line axis?

[bhaveshp90]

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

[vamsee]

May be add Project No as Dimension.

Your dimension says 'GM_Per_Bucket'

[bhaveshp90]

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)

[vamsee · Accepted solution]

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

QlikView: Multiple Dimensions and Expressions in Bar Chart - ΛUΤΟΞΧΞ©