Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
Not applicable

Format a row in a valuelist

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.

1 Solution

Accepted Solutions
krishna_2644
Valued Contributor III

Re: Format a row in a valuelist

yes you can.

See attached.

Capture1.PNG

5 Replies
krishna_2644
Valued Contributor III

Re: Format a row in a valuelist

yes you can.

See attached.

Capture1.PNG

Not applicable

Re: Format a row in a valuelist

Hi Check Multi Colored check box here

Capture.JPG

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

krishna_2644
Valued Contributor III

Re: Format a row in a valuelist

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

we have to input expressions .

Not applicable

Re: Format a row in a valuelist

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

Not applicable

Re: Format a row in a valuelist

Thanks a lot, it works