topic Re: Font color in expression in QlikView

Font color in expression

Wed, 25 Nov 2020 16:16:04 GMT

This code works fine (it just make a format so numbers under one percent show a decimal, else show a interger) - but I want the code to change the font color as well - how do I do that?

if ((

SUM({1<Year={$(v_year)}>} DKK))/ (SUM({1<Year={$(v_year)}>} TOTAL DKK))<0.01, NUM((SUM({1<Year={$(v_year)}>} DKK))/ (SUM({1<Year={$(v_year)}>} TOTAL DKK)), '#.##0,0%') ) &

if ((

SUM({1<Year={$(v_year)}>} DKK))/ (SUM({1<Year={$(v_year)}>} TOTAL DKK))>=0.01, NUM((SUM({1<Year={$(v_year)}>} DKK))/ (SUM({1<Year={$(v_year)}>} TOTAL DKK)), '#.##0%') )

Can I add a font style?

Thanks in advance 🙂

(By the way my code is used in the Ideovision Map extension, but I think its a common issue for all expressions)

Re: Font color in expression

wojciechd — Tue, 07 Mar 2017 17:27:57 GMT

I'm sorry, but is the regular text formatting not available? is this code from your expression?

Can you not create similar if statement in the Text Color formatting expression?

ex.

=if(<your condition>,White(),Black())

or multiple if statements if you need more of a gradient

=if(<your condition>,White(),

if(<your condition>, rgb(34,255,34),

if(<your condition>, rgb(224, 224, 224),

)

Re: Font color in expression

Tue, 07 Mar 2017 21:30:53 GMT

Thanks - but in the extension idevio I can only work in the webview and there is no access to the regular text formatting thats why I want to do in my expression 🙂 So unfortunately I cant use your suggestion, but thanks anyway for trying 🙂

Re: Font color in expression

avinashelite — Wed, 08 Mar 2017 05:52:32 GMT

I think in the extension you need have the code to handle the font size I guess ..Since you have the extension add the code to handle the font color in the extension that way you will have more option

Re: Font color in expression

Thu, 09 Mar 2017 10:15:41 GMT

well its not a general change - I want to control the font color for the label by an IF-statement. I know I can't use NUM-function, because this only format the numbers. Therefore: I can't find a function to handle font color when I want to write my IF statement in the expression in the label fx-box.

Re: Font color in expression

avinashelite — Thu, 09 Mar 2017 10:32:01 GMT

So your label is a combination of text and num? then we don't have a way to handle that ..could give an example

if its only the numbers then something like this would work

if(exp>1.0 , RGB(245,36,65), if(exp=100,RGB(),RGB()))

Re: Font color in expression

Thu, 09 Mar 2017 10:51:59 GMT

Thanks - great feedback - now its close to success, but no cigar yet 🙂

Now the labels are not longer numbers but a textstring: RGB(245,36,65) ... and the textstring code changes along with the if-statement. Thats ok, but code dont execute the RGB to a color, so I read my label in the color ... do you have any suggestion to get through that hurdle? Thank you so much in advance 🙂

My wish is that I can change the label color at the area white dark background color at the maps below 🙂
(and it changes over time, that why I want to control it with the IF-statement)

Re: Font color in expression

avinashelite — Thu, 09 Mar 2017 11:00:32 GMT

You need to paste the color expression in the Expression tab>+ mark and paste it hear and the regular expression in the expression definition box so it actually to different location

Re: Font color in expression

Thu, 09 Mar 2017 11:12:11 GMT

I really appreciate your help - but Im not sure what you mean. I use the expression box at the [LABEL] section:

And the simple test of color

=if((SUM({1<Year={$(v_year)},Fou_geo={'DK'}>} DKK))/ (SUM({1<Year={$(v_year)},Fou_geo={'DK'}>} TOTAL DKK))<0.01, RGB(245,36,65), RGB(245,245,245))

This gives the picture in shown in my recent post ... Do you think Im writing the code at the wrong place?

Re: Font color in expression

avinashelite — Thu, 09 Mar 2017 11:38:21 GMT

This is the palace to define your label name their will be an option to choose the Label font color , their you need paste the RGB() if condition expression to pick the color

Hope you got the answer

Re: Font color in expression

Thu, 09 Mar 2017 12:52:51 GMT

Thanks - then I dont think there is a solution. The only color option I have is the background color and that works fine - I cant find a place to change label color. I think I make a textbox and order it to the front of the map instead. Thank you very much for your time 🙂

Re: Font color in expression

avinashelite — Thu, 09 Mar 2017 12:57:38 GMT

Since it's an extension we need to add the logic code in the extension to change the Label color ..if it was a QV default object it would come by default . Get in touch with your extension developer and ask to add this part also

Re: Font color in expression

Anil_Babu_Samineni — Thu, 09 Mar 2017 13:02:33 GMT

I am new to extension oriented

Try this?

<Label Id = "LabelID"> Welcome </Label>

<Style>

#LabelID

{

Color : Red;

Font-Weight : Bold;

}

</Stlye>

Or else simple do this with in the tag if you feel bad in Styles

<Label Style = "Color : Red; Font-Weight : Bold"> Welcome </Label>

Re: Font color in expression

avinashelite — Thu, 09 Mar 2017 14:04:56 GMT

He want the labels to change as per the expression the above gives the constant color for him rite ?

Re: Font color in expression

adamdavi3s — Thu, 09 Mar 2017 14:06:36 GMT

It would be easy enough to add this into the script for the extension, but guessing that is down to the developer...

Is this a paid extension I assume?

Re: Font color in expression

Thu, 09 Mar 2017 14:47:01 GMT

Yes its a paided extension: Ideovio which is a very nice map for QV. I'll ask them and be back with the feedback here 🙂