topic Re: Format a row in a valuelist in QlikView

Format a row in a valuelist

Thu, 30 Jul 2015 21:07:54 GMT

Hi,

I'm using a Valuelist() function as dimension in a straight table and Pick() for the expressions. However I'm looking to change the background/text color for certain items in the pick list. Here is the dimension/expression example:

Dim:

=ValueList('Revenue','Expenses','Gross Profit')

Exp:

=Pick(Match(ValueList('Revenue','Expenses','Gross Profit'),

'Revenue','Expenses','Gross Profit'),

sum(Revenue),

sum(Expenses),

Sum(Gross Profit))

So is it possible to format (change the background/text color) of the Gross Profit row only or any other row individually within the same expression?

Thanks.

Re: Format a row in a valuelist

Qrishna — Thu, 30 Jul 2015 21:22:10 GMT

yes you can.

See attached.

Re: Format a row in a valuelist

Thu, 30 Jul 2015 21:22:12 GMT

Hi Check Multi Colored check box here

Also you can use Background color/Text color if it is straight table.

Re: Format a row in a valuelist

Qrishna — Thu, 30 Jul 2015 21:25:30 GMT

you wont be having colors tab for st and pivot tables instead we have visual cues.

we have to input expressions .

Re: Format a row in a valuelist

Thu, 30 Jul 2015 21:42:24 GMT

yes, 1st is for other charts except Straight TB and Pivot Tb

Re: Format a row in a valuelist

Thu, 30 Jul 2015 21:59:43 GMT

Thanks a lot, it works