Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
Highlighted
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

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

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, 😃