topic Re: Change Symbol Colour in QlikView

Change Symbol Colour

Anonymous — Fri, 02 Jun 2017 06:57:17 GMT

Hi All,

I am creating combo chart wherein Primary Axis is Bar chart and Secondary Axis is line Char with Symbol.

Now I want to change only Symbol colour. Is it possible in Qlikview?

Re: Change Symbol Colour

Peter_Cammaert — Fri, 02 Jun 2017 07:11:17 GMT

Yes. In the secondary expression (the one that is shown using Symbols), expand the expression tree and set the Background color to some value depending on the outcome of the same expression you are using to position the symbol.

See here for an example (chart 2): Visual tricks with Charts

Re: Change Symbol Colour

prma7799 — Fri, 02 Jun 2017 07:16:36 GMT

Create two identical expressions in your line chart. For one of them, use display option line, and for another symbol. For the symbol version, use conditional background color (see attribute expresions) according to your rules, whatever the rules may be.

Re: Change Symbol Colour

Anonymous — Fri, 09 Jun 2017 03:23:07 GMT

Thanks, PM

It's working fine, but I want to fill the symbol with colour.

Can it be possible?

Re: Change Symbol Colour

prma7799 — Fri, 09 Jun 2017 03:59:04 GMT

Like this ???

Or please share your sample output with expected color.

Re: Change Symbol Colour

Anil_Babu_Samineni — Fri, 09 Jun 2017 04:03:59 GMT

check here from expression tab

Re: Change Symbol Colour

prma7799 — Fri, 09 Jun 2017 04:08:00 GMT

Hi Anil ,

Here no need to tick line ..

Re: Change Symbol Colour

Anil_Babu_Samineni — Fri, 09 Jun 2017 04:09:52 GMT

Your solution uses for only if they need 2 colors. But, My solution gives the Same color in single metric, Any how thanks

Re: Change Symbol Colour

Anonymous — Fri, 09 Jun 2017 04:36:17 GMT

Thanks, Anil

For your valuable input.

But If I select Diamond how will I fill it.

Re: Change Symbol Colour

prma7799 — Fri, 09 Jun 2017 04:41:15 GMT

Like this?

Just change it to Diamonds

Re: Change Symbol Colour

Anonymous — Fri, 09 Jun 2017 04:48:39 GMT

I am not getting the desired result

Re: Change Symbol Colour

prma7799 — Fri, 09 Jun 2017 04:55:49 GMT

Can you please share sample application ...

Re: Change Symbol Colour

Anonymous — Fri, 09 Jun 2017 05:01:12 GMT

I have used 3 expression

1) First for Bar chart that is duplicate percentage

2) Line chart that is duplicate of First Expression

3) Symbol is duplicate of Second Expression ( Diamonds )

Re: Change Symbol Colour

Anil_Babu_Samineni — Fri, 09 Jun 2017 05:19:05 GMT

Can you cross check what P M shared the qvw. Seems,He checks the Dots symbol for one expression. From your end you can do same for 2nd expression

Re: Change Symbol Colour

Anonymous — Fri, 09 Jun 2017 05:24:12 GMT

Thanks Anil,

I don't have access for Qvw file as I am using Personal Edition.

So i request you to share the steps with me.

We are in process, soon we will go for licence once we are familiar with the QlikView.

Re: Change Symbol Colour

prma7799 — Fri, 09 Jun 2017 05:30:50 GMT

Hi Bijay,

As i said

"Create two identical expressions in your line chart. For one of them, use display option line, and for another symbol. For the symbol version, use conditional background color (see attribute expresions) according to your rules, whatever the rules may be."

Re: Change Symbol Colour

Anil_Babu_Samineni — Fri, 09 Jun 2017 05:31:37 GMT

In fact, There is no steps to follow. Here, For your second expression try to enable symbol as Dots with Line then you will achieve

Re: Change Symbol Colour

Anonymous — Fri, 09 Jun 2017 05:37:52 GMT

Thanks, Anil

Now, let's take your situation as an example.

Line Colour must be in Orange and symbol must be in diamond filled with red colour.

Re: Change Symbol Colour

prma7799 — Fri, 09 Jun 2017 05:42:01 GMT

I think this is not possible you have do like below only.

Re: Change Symbol Colour

Anil_Babu_Samineni — Fri, 09 Jun 2017 05:45:17 GMT

We will definitely help you reg this, I would suggest you to share application for mock which demonstrates the issue. Then, I may share the steps whether direct way or work around.