topic Text Box in QlikView

Text Box

upaliwije — Thu, 16 Oct 2014 04:04:38 GMT

I have a text box and I have following command typed in it

= VEHICLE_TYPE

When I select Vehicle Type from a List box the relevant vehicle type appear in my text box correctly. But when I do not select any vehicle type from my list box I want to 'ALL VEHICLES' to appear in my Text Box. Pls help me how to do it

Re: Text Box

preminqlik — Thu, 16 Oct 2014 04:15:13 GMT

hi try this

=Concat(VEHICLE_TYPE,chr(13))

Re: Text Box

upaliwije — Thu, 16 Oct 2014 04:44:45 GMT

Then All vehicles are listed. What I want is to 'ALL VEHICLES' as one word to appear in Text Box

Re: Text Box

danieloberbilli — Thu, 16 Oct 2014 04:45:48 GMT

copy the following in your textbox (including the equal sign at the beginning):

=if(GetSelectedCount(VEHICLE_TYPE)=0,'ALL VEHICLES',VEHICLE_TYPE)

Kind Regards

Daniel

Re: Text Box

upaliwije — Thu, 16 Oct 2014 04:51:16 GMT

Thanks Both of You

Re: Text Box

upaliwije — Thu, 16 Oct 2014 04:54:43 GMT

Dear Danial

Will you please help me also how to blink the text in text box

Re: Text Box

danieloberbilli — Thu, 16 Oct 2014 05:01:43 GMT

what do you mean with 'blink'?

Re: Text Box

sasikanth — Thu, 16 Oct 2014 05:07:34 GMT

Increase the Boarder and shadow in Layout tab

Re: Text Box

upaliwije — Thu, 16 Oct 2014 05:13:53 GMT

I mean Text (Vehicles Type) to blink like flashing a light

Re: Text Box

PrashantSangle — Thu, 16 Oct 2014 05:21:15 GMT

Hi,

To acheive this requirement, go for macro or use extension object.

Regards

Re: Text Box

upaliwije — Thu, 16 Oct 2014 05:28:14 GMT

Tks

Pls provide an example

Re: Re: Text Box

danieloberbilli — Thu, 16 Oct 2014 05:44:25 GMT

See .qvw attached. properties > General tab > Background color > Calculated > enter an expression like the one here:

Re: Re: Text Box

danieloberbilli — Thu, 16 Oct 2014 05:45:17 GMT

but this might not work on a server version.

Re: Text Box

upaliwije — Thu, 16 Oct 2014 06:01:12 GMT

Tks

It is working Fine