topic Re: Formatting Text on a Button in QlikView

Formatting Text on a Button

Fri, 21 Mar 2014 15:16:46 GMT

I would like the text on the buttons atached to turn red when active.

The toggle facility is loaded into each button and the user can add stops by clicking on each button in turn. I can only get one button at a time to show as red text but what I want is for the text on each button to remain red until the selection is cleared

Re: Formatting Text on a Button

stevedark — Fri, 21 Mar 2014 15:27:51 GMT

Hi Glenn,

You want the expressions:

=If(maxstring({<Stop*={'MKT'}>}Stop)='MKT',LightRed())

and

=If(maxstring({<Stop*={'PIC'}>}Stop)='PIC',LightRed())

Note the * symbol in the Set Analysis - this takes into account your actual selections in that field and overlays the value in the set. This should then give you the highlighting you want.

Steve

Re: Formatting Text on a Button

Gysbert_Wassenaar — Fri, 21 Mar 2014 15:29:38 GMT

Try =If(GetSelectedCount(Stop) AND SubStringCount(concat(distinct '^'& Stop & '^'),'^MKT^'),LightRed())

See attached qvw.

Re: Formatting Text on a Button

MK_QSL — Fri, 21 Mar 2014 15:30:57 GMT

Like this?

Re: Formatting Text on a Button

Anonymous — Fri, 21 Mar 2014 15:30:58 GMT

or simply

if(GetFieldSelections(Stop) like '*PIC*',lightred())

for PIC button font color and

if(GetFieldSelections(Stop) like '*MKT*',lightred()) for MKT button font color

Re: Formatting Text on a Button

SunilChauhan — Fri, 21 Mar 2014 15:31:13 GMT

see the attched image

hope this helps

Re: Formatting Text on a Button

Gysbert_Wassenaar — Fri, 21 Mar 2014 15:32:55 GMT

Wow, that's an elegant solution. Thank you for that.

Re: Formatting Text on a Button

MK_QSL — Fri, 21 Mar 2014 15:37:53 GMT

Hi Gysbert,

Nice solution...

is there any specific reason you have added...

'^'& Stop & '^'

Re: Formatting Text on a Button

stevedark — Fri, 21 Mar 2014 15:42:43 GMT

Thanks Gysbert.

I'm a big fan of using colours on text boxes to convey information, so often use solutions like that one. I've a number of tips an tricks explained in this example document:

QlikView App: At The Qlik Of A Button

Steve

Re: Formatting Text on a Button

Gysbert_Wassenaar — Fri, 21 Mar 2014 15:45:18 GMT

To make sure only the right Stop value (the exact match) will be matched by the substringcount function. But Steve's solution is much nicer. It a lot simpler and shorter.