Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
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
Highlighted
Specialist
Specialist

May be add Project No as Dimension.

Your dimension says 'GM_Per_Bucket'

Highlighted
Creator III
Creator III

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)

Highlighted
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