topic need help in Line Chart?? in QlikView

need help in Line Chart??

soha1902 — Tue, 17 Jun 2014 11:01:58 GMT

Hi All,

I m using one line chart where I am showing sales per year.

Now I want to know is this possible to use two symbols in same line. Suppose if sales is greater then previous year then up trangle and if small then down trangle.

Also Want to know Can we use seprate colors for Line and symbols.

Please help.

Re: need help in Line Chart??

Gysbert_Wassenaar — Tue, 17 Jun 2014 11:06:40 GMT

You can't use two different symbols. You would have to use two expressions. One with up triangles and one with down triangles.

You can set the colors by clicking on the + in front of the expression select Background Color and enter an expression to calculate the color: if(sum(Sales)<above(sum(Sales)),red(), color(1))

You can't use different colors for symbol and line. But you can use two expressions, one for the symbol and one for the line. That way you can give both different colors.

See attached example.

Re: need help in Line Chart??

soha1902 — Tue, 17 Jun 2014 11:14:30 GMT

Thanks a lot Gysbert. You made my day.

One small question...I am using two expression one for line and one for symbol.

Now its showing two legends. I want to show only line legend and want to hide symbol related legend.

Is this possible???

Re: need help in Line Chart??

Gysbert_Wassenaar — Tue, 17 Jun 2014 11:17:48 GMT

Nope. You can hide the legend, but not pick and choose which expressions to show in the legend and which to hide.

Re: need help in Line Chart??

perumal_41 — Tue, 17 Jun 2014 11:21:36 GMT

Hi Soha,

PFA,try is useful for u or not

Regards,

Perumal A

Re: need help in Line Chart??

soha1902 — Tue, 17 Jun 2014 11:29:28 GMT

Very Nice.....Thank you very much....