Conditional formatting in a single text-box

[Anonymous]

Hi everyone,

I need help in using conditional formatting in part ot the text using just one text box. I know I can use multiple boxes, but if possible i would like to know how to do it with a single text box:

Expected result If sales are < 0 a single box with:

Sales -100€

Expected result If sales are > 0 a single box with:

Sales 100€

Does anyone know if it is possible?

Thanks in advance!

[Jason_Michaelides · Accepted solution]

There are lots of posts on this.  Certainly up to v10 this is not possible.  I don't think it has been introduced in v11 either.  There is an idea for this - please vote for it!

http://community.qlik.com/ideas/1880

Hope this helps,

Jason

[#3]

This link is broken now.

[Anonymous]

Thanks for your feedback Dave,

I searched on this idea and couldnt find it either. Perhaps it was Appproved, or Closed? Perhaps Jason can post some additonal feedback. I will also email him.

Cheers!

[Jason_Michaelides]

For some reason the link I posted is trying to naviagate to page different to the one it shows!  Try this one (looks the same!)

http://community.qlik.com/ideas/1880

[Jason_Michaelides]

OK - there's something wrong with creating links here!  If you type in exactly what I have written into the URL it'll work, however the link does not!

[#7]

Hi Jason,

Hovering over the link shows it's prefixing your url with 'community.qlik.com/ideas' - if I just take the URL you are displaying at paste it into a new window it works fine.

Thanks for drawing my attention to the Text Box Formatting thread!

[#8]

ugh, now it's doing to me too!