Add horizontal line with expression or reference line in chart

emyemyemy — Tue, 02 Oct 2018 14:39:32 GMT

Hello ,

I have table 1 and table2 bellow :

tale1 :

LOAD week
workshop,
numSUM(defaut1,defaut2) as sumDefaut

FROM
[path]
(ooxml, embedded labels, table is sheet1)
;
table2:
LOAD ,
workshop,
limit
FROM
[path]
(ooxml, embedded labels, table is sheet2) ;

my chart line is created from table1 :

Dimension1 = week

Dimension 2 = workshop

expression1 = if ( workshop = inputText , sum(sumDefaut))

until this level every thing is working very well .

Now I want to add horizontal line refer to avg(limit) in my chart using add new expression2 with condition used in dimension : if(workshop = inputText, avg(Limit))

result : first expression1 disappear and the new exp2 appear ( horizontal line) ,

I tired with adding reference line : if (workshop = inputText, avg(Limit)) also I tried it with Constant but nothing shows .

I wish this is clear , I'll be grateful for any help and attention

Re: Add horizontal line with expression or reference line in chart

emyemyemy — Wed, 03 Oct 2018 10:17:50 GMT

Hello ,

I changed chart type from chart line to Combo chart .

Both expressions shows .

topic Re: Add horizontal line with expression or reference line in chart in QlikView

Add horizontal line with expression or reference line in chart

Now I want to add horizontal line refer to avg(limit) in my chart using add new expression2 with condition used in dimension : if(workshop = inputText, avg(Limit))

Re: Add horizontal line with expression or reference line in chart