Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

sabmaldun
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

1 Solution

Accepted Solutions
Highlighted

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)

View solution in original post

2 Replies
Highlighted

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)

View solution in original post

sabmaldun
New Contributor II

Re: Ignoring category in combochart to show straight line

This worked.

Thank you, 😃