topic Format background in QlikView

Format background

Thu, 24 Mar 2011 14:27:51 GMT

I need help.
I want to change the background color of a Concepto dimension when I select the variablevConceto.

So far no problem. I've done with this function.

if (Concepto = vConcepto,rgb(191,191,191),

if(Total='1.- Ventas',

if((rowno()=0),rgb(216,228,188),rgb(235,241,222)),

if((rowno()=0),rgb(230,184,183),rgb(242,220,219))))

The problem is when I choose two values ??in the variable vConcepto

Happens nothing:

Any ideas?

matt_crowther — Thu, 24 Mar 2011 15:12:12 GMT

Paco,

Look to use a combination of the match() and concat() functions - the help file should explain.

You'd essentially try to match the variable to the concat of the selected values from the list box.

Unchecked:

=if(match(Concepto,concat(vConcepto,', ')),rgb(191,191,191))

Hope that points you in the right direction.

Matt - Visual Analytics Ltd

Thu, 24 Mar 2011 15:28:01 GMT

Does not work. I'll try to pull support.
Thanks

matt_crowther — Thu, 24 Mar 2011 16:03:55 GMT

Paco,

I knew I was on the right track - solution attached (hopefully).

Using in the Background format:

=if(substringcount(concat(vCountry,', '),COUNTRY)<>0,rgb(198,255,198))

Hope that solves it.

Matt - Visual Analytics Ltd

Fri, 25 Mar 2011 10:14:25 GMT

Comes very close to what I want. But when it selects no way I like to keep the colorschosen ....

matt_crowther — Fri, 25 Mar 2011 11:26:08 GMT

Paco,

Not entirely sure what the remaining issue is but this may solve it:

=if(substringcount(concat(vCountry,', '),COUNTRY)<>0,rgb(198,255,198),rgb(255,198,198))

Where the first rgb() is your highlight when selected colour and the second rgb() is the default red background.

If you need a further level of control on the background you can add another 'if' function in place of the second rgb() value.

Hope that helps,

Matt - Visual Analytics Ltd