topic Re: Line color multiple input box or transparent background in QlikView

Line color multiple input box or transparent background

Sat, 31 Dec 2011 12:56:59 GMT

Hello,

Is it possible to change the color of the lines between the cells in a multiple input box ?

When this is not possible, can I make the background transparent so I can put an empty table behind it to simulate the lines ?

Auke

Line color multiple input box or transparent background

swuehl — Sat, 31 Dec 2011 13:59:59 GMT

Not sure if you can change the line color, haven't found a setting for this.

You can set the background to transparent in presentation tab, select variable and then change row colors / background. Check that no background is set in background dialog at the bottom of this tab (or use / set an image here to achieve what you want).

Regards,

Stefan

Re: Line color multiple input box or transparent background

Sat, 31 Dec 2011 14:19:00 GMT

Stefan, thank you.

At first it dit not work. In Document Properties|General|Color Scheme was set as Light.

When I changed this in [Custom] the Input box got transparent, also my Listbox went bananas (colors).

When I changed the Color Scheme back to Light the Input box stays transparent, to my surprise.

Auke

Line color multiple input box or transparent background

swuehl — Sat, 31 Dec 2011 14:24:46 GMT

Hm, mine color scheme is and was set to Light too. Input box went to transparent without changing the color scheme. I am using QV11. Probably one of the QV surprises...

Happy new year!

Re: Line color multiple input box or transparent background

Sat, 31 Dec 2011 14:41:09 GMT

I use QV10 SR2.

This is my final 'Input grid', made of a List box, 3 multiple Input boxes and a Tabel box for the lines.

This way I can make my own selections in different fields.

Auke

Line color multiple input box or transparent background

swuehl — Sat, 31 Dec 2011 14:49:12 GMT

Looks interesting...

So you basically keep a set of variables with search expressions and then have another "selector" to select the appropriate set of search expression (one line in above table) and apply them to fields Materiaal, Voorraf, Spoelbak? Like a shortcut for those searches?

Re: Line color multiple input box or transparent background

Sat, 31 Dec 2011 15:16:52 GMT

Yes, see screenshot.

A trigger on the variable updates the other objects.

Is it possible to make a standard function for the If(..) expressions with the index and part variable replaced with $1 and $2, so I can change the variable into myFunction($1, $2) ?

Auke

Line color multiple input box or transparent background

swuehl — Sat, 31 Dec 2011 15:31:19 GMT

Yes, this could be possible, please look into dollar-sign expansion with parameters in the Help file.

Re: Line color multiple input box or transparent background

Sat, 31 Dec 2011 16:04:19 GMT

Thanks, I created a 'function variable' vZoekFunctie

If((Index(GetFieldSelections(expno, ','), $1) <> 0) and ($2 <> '*|*|*'

,' or Zoekstring like ' & chr(39) & $2 & chr(39))

and replaced the original variable with

= '= Zoekstring = 1'

& $(vZoekFunctie(1, vExpr1))

& $(vZoekFunctie(2, vExpr2))

& $(vZoekFunctie(3, vExpr3))

& $(vZoekFunctie(4, vExpr4))

& $(vZoekFunctie(5, vExpr5))

& $(vZoekFunctie(6, vExpr6))

Nice and short.

Auke