Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

yadav_anil782
Contributor

color chage require according to given expressions

Dear All,

i'm giving this expression for change the chart line value , i want  ">=" values in blue and "<" values in red . then what expression should be correct.  now i'm using this expression-=if( 'Net  Amount'<0,red(),blue())

2nd-  i  have  two expression  in chart  1st- for "receievd amount" and 2nd is  " future collection"   and i want to show  "receievd amount" in normal line and " future collection" in breck line but breck line  and its not happning.  i can  take only symble and can remove line in  expession tab but brecking line is not coming full its showig only dots(.)  in given  time series

plz reply if any one can help for the same

1 Reply
prajapatiamar38
Contributor II

Re: color chage require according to given expressions

Hi

For color change of lines see the attached screenshot below.Go to exp>background color write color exp.


And  for line break try like this expression.

Go to expression tab>Expand the expression>Line Style write like this exp below

=If((Year)<=2011,'<S1>','<S2>')

Hope this will help you.

Thanks

Community Browser