topic Re: Straight table Color Change in QlikView

Straight table Color Change

sona_sa — Fri, 12 Jul 2013 08:19:07 GMT

Hi,

I Have a sheet. There is multibox and a sraight table. I what whatever field selection is done in that particular multibox, That dimension font color or Back ground color should to be changed in that straight table.

At a time there is only one selection always will be done.

For ref. please check out attached jpeg.

Thanks

Re: Straight table Color Change

jonathandienst — Fri, 12 Jul 2013 08:27:32 GMT

Do you mean that you want to highlight a column in the table when that column is selected in the listbox?

You can place an colour expression for the background colour or font colour for each chart expression that checks the selected value and changes the colour accordingly. Something like:

For postal code:

=If([Column Name] = 'Postal Code', LightRed())

For fill date:

=If([Column Name] = 'Fill Date', LightRed())

etc

For a more comprehensive solution, I suggest that you upload a sample of your model.

Regards

Jonathan

Re: Straight table Color Change

Fri, 12 Jul 2013 09:42:19 GMT

Go expression>select Background colour and try below scripts..

pick(match([Column Name], 'POSTAL_CD'),

rgb(255,0,0))

regards-bika

Re: Straight table Color Change

sona_sa — Fri, 19 Jul 2013 08:52:19 GMT

Can u use the same in the attached QVW file.

Thanks for Reply.

Re: Straight table Color Change

sona_sa — Fri, 19 Jul 2013 09:02:14 GMT

Please find the attached QVW for the same.

Thanks.

Re: Straight table Color Change

Fri, 19 Jul 2013 09:42:32 GMT

Pls try to use pivot table..

find it attached

Re: Straight table Color Change

sona_sa — Fri, 19 Jul 2013 10:00:25 GMT

Hi Thanks for reply.

According to the solution.... I need whatever I will select in Multibox, That particular colomn color should to change. If Select POSTAL_CD in Multibox the straight table color should to change and If state_cd then State_cd column color.

Re: Straight table Color Change

sona_sa — Fri, 19 Jul 2013 10:00:36 GMT

Hi Thanks for reply.

Re: Straight table Color Change

Fri, 19 Jul 2013 10:05:38 GMT

Just i am manually fixed the column heading colour. no condition