topic Re: Coloring line chart by two dimension in QlikView

Coloring line chart by two dimension

undergrinder — Thu, 10 Dec 2015 21:56:41 GMT

Hi All,

Is it possible to coloring line chart by two dimension?

First dimension: Date

Second dimension: Product

+Measure: Count(Sales)

The data are facts and prediction as well.

I would like to color the prediction gray, product1 facts blue, product2 facts red.

I know it is aplicable by one dimension (Date), and with 4 measure, but it will be more elegant.

The color by expression like if(date>Date_prediction_dt,lightgray(),if(dim1='product1',blue(),red())

Thanks!

Re: Coloring line chart by two dimension

robert_mika — Thu, 10 Dec 2015 22:10:40 GMT

If you could not find the easy way you can always create two objects (graphs) and put one on another make some colors transparent or hide.

Feeling Qlikngry?

How To /Missing Manual(23 articles)

Re: Coloring line chart by two dimension

Thu, 10 Dec 2015 22:48:43 GMT

You could have four measures in the Expressions tab. First two measures show actuals. Second two show predictions. First two stop showing data when the facts run out and the second two starting showing data when the facts run out.

You can disable the second lines from showing up on the legend by unchecking the "Expressions as legend" box at the bottom of the Expressions tab.

Re: Coloring line chart by two dimension

MarcoWedel — Fri, 11 Dec 2015 00:42:50 GMT

Hi,

one solution could be:

hope this helps

regards

Marco

Re: Coloring line chart by two dimension

undergrinder — Fri, 11 Dec 2015 01:24:09 GMT

Thank You all!

I'm sorry I haven't mentioned, but I use Qlik Sense 1.1, not QlikView.

I thought this topic is all about Sense, therefore I forget.

@Martin: Thank you, I've already tried it, it works, but I look a more beuty solution, like color by expression.

@Marco: Thank you, nice solution, but it isn't suitable because of Sense.

@Robert: I don't get it exactly, what you mean.

Re: Coloring line chart by two dimension

robert_mika — Fri, 11 Dec 2015 04:15:30 GMT

Sense 1.1?

Any reason why you do not change for 2.0?

My solution is for View you can not have overlapping objects in Sense

Still I like your solution Marco.

Re: Coloring line chart by two dimension

Fri, 11 Dec 2015 07:39:52 GMT

Hi,

Why can't we try by defining the calculated colours in the colors tab..

Re: Coloring line chart by two dimension

undergrinder — Sun, 13 Dec 2015 16:43:54 GMT

Hi Robert,

It is hard to explain why we still use Qlik Sense 1.1, but I have to working with it.