Discussion Board for collaboration related to QlikView App Development.
I have table 1 and table2 bellow :
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 .
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
Go to Solution.
I changed chart type from chart line to Combo chart .
Both expressions shows .