topic Re: Color messing up when I add expressions in QlikView

Color messing up when I add expressions

hjm35055 — Wed, 14 Dec 2016 16:50:52 GMT

Hi!

So I have the following chart. As you can see, there are not that many employees showing and it is repeating colors which should NOT be happening.

I believe the reason this is happening is because I have 3 expressions that are only "text as a pop-up". These are needed for a custom pop-up label.

When I remove the 3 "text as pop-up" expressions, it works fine!

Anyone know a way to fix this and keep those expressions??

Thank you!!!

Re: Color messing up when I add expressions

vishsaggi — Wed, 14 Dec 2016 17:07:50 GMT

Can you share a sample app with just this chart if possible? In the chart properties Colors tab what are the sequence of colors there ? Before and after the expressions?

Re: Color messing up when I add expressions

hjm35055 — Wed, 14 Dec 2016 17:15:52 GMT

Sample is attached.

Re: Color messing up when I add expressions

vinieme12 — Wed, 14 Dec 2016 17:16:40 GMT

Experiment by Creating a DUAL Expression and remove the other pop ups

example

DUAL( TEXXT & TEXT & TEXT , sum(whatever) )

Re: Color messing up when I add expressions

hjm35055 — Wed, 14 Dec 2016 17:58:10 GMT

Thanks! I got the dual expression to work. The only issue now is that all the text is on one line. Is there a way in the expression to add it to a different line?

My current expression is:

Dual(Name
&IF(IsNull(GetFieldSelections([Person Type])),[Person Type],'')
&IF(IsNull(GetFieldSelections(Position)),Position,''),
count({<[Skill/Trait]={'Logic, Deduction, & Reasoning'}>}Score))

I would like it to be:

Hermelinda Stollings

Employee

Thank you!

Re: Color messing up when I add expressions

vinieme12 — Wed, 14 Dec 2016 18:00:31 GMT

Dual(Name & cHR(10)

&IF(IsNull(GetFieldSelections([Person Type])),[Person Type],'') & chr(10)

&IF(IsNull(GetFieldSelections(Position)),Position,''),

count({<[Skill/Trait]={'Logic, Deduction, & Reasoning'}>}Score))

If you want 2 or more line spaces use repeat(chr(10),2)

Cheers