Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld online is next week! REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
bhaveshp90
Creator III
Creator III

How to fix this Bar chart with Line axis?

Hello,

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

cap.PNG

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

1 Solution

Accepted Solutions
vamsee
Specialist
Specialist

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ΤΟΞΧΞ©

View solution in original post

3 Replies
vamsee
Specialist
Specialist

May be add Project No as Dimension.

Your dimension says 'GM_Per_Bucket'

bhaveshp90
Creator III
Creator III
Author

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
Specialist
Specialist

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ΤΟΞΧΞ©