topic Re: Text formatting in QlikView

Text formatting

Mon, 24 Mar 2014 18:04:09 GMT

In the example attached I click a stop i want the value in the second row down to turn RED

The value in the box turns red if one is selected but goes off when another is selected which isnt what I want

If i chose say Market St (MKT) and Shudehill (SHU) I would want them both to remain RED

Re: Text formatting

Anonymous — Mon, 24 Mar 2014 18:10:48 GMT

use the following expression as calculated background color

for MKT text box,

if(GetFieldSelections(Stop) like '*MKT*',red())

similarly the other ones and modify as needed. red() can be replaced with your color of choice (even your color mix expression will work) and make sure you keep the two asterisks (*) inside the single quotes.

Re: Text formatting

its_anandrjs — Mon, 24 Mar 2014 18:24:20 GMT

Hi,

Write like this in the text box for the text color

for VIC If(Match(Stop,'VIC'),LightRed())

for MKT If(Match(Stop,'MKT') or GetSelectedCount(Stop)=0,LightRed())

for SHU If(Match(Stop,'SHU') or GetSelectedCount(Stop)=0,LightRed())

Hope this helps

Thanks & Regards

Re: Text formatting

Tue, 25 Mar 2014 11:33:48 GMT

Thats great thanks. May I ask what the code would be if i wanted to add a second condition

ie if i wanted SPS to turn red when either SPS or MKT were selected

Te reason I ask this is that I want to add a line selection

Re: Text formatting

Anonymous — Tue, 25 Mar 2014 13:50:58 GMT

i'm sorry, i don't understand what you mean by second condition. could you elaborate?

but with the expression in my reply, it will work with multiple selections.

play with the conditions in the if statement if you need to add more conditions/requirements...

something like this should work for "if i wanted SPS to turn red when either SPS or MKT were selected":

for SPS text box,

if(GetFieldSelections(Stop) like '*MKT*' or GetFieldSelections(Stop) like '*SPS*',red())