# New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

New Contributor II

## Ignoring category in combochart to show straight line

Hello,

I would like to create just a straight reference line according to this Expression in a combochart:

`(SUM({<Year={"\$(=MAX(Year))"},Month={"<=\$(=MAX(Month))"}>}TOTAL <Category>PartSales)/SUM({<Year={"\$(=MAX(Year))"},Month={"<=\$(=MAX(Month))"}>} TOTAL <Category>Throughputs))`

The Barchart of the combochart has "Category" as Dimensions and I want to ignore this Dimension to Show a straight line of the value which results of the Formula.

I tried with total qualifier as I read in another thread, but it did not work for me.

Anyone has a Suggestion, how to solve the Problem?

Either ignore Dimension or convert the Formula into a fixed numbervalue?

Thank you,

Regards Jonas

Tags (3)
1 Solution

Accepted Solutions
Highlighted MVP

## Re: Ignoring category in combochart to show straight line

Did this not work?

```Sum({<Year = {"\$(=Max(Year))"}, Month = {"<=\$(=Max(Month))"}>} TOTAL PartSales)/
Sum({<Year = {"\$(=Max(Year))"}, Month = {"<=\$(=Max(Month))"}>} TOTAL Throughputs)```
2 Replies
Highlighted MVP

## Re: Ignoring category in combochart to show straight line

Did this not work?

```Sum({<Year = {"\$(=Max(Year))"}, Month = {"<=\$(=Max(Month))"}>} TOTAL PartSales)/
Sum({<Year = {"\$(=Max(Year))"}, Month = {"<=\$(=Max(Month))"}>} TOTAL Throughputs)```
New Contributor II

This worked.

Thank you, 😃