Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Specialist III
Specialist III

yes you can.

See attached.

Capture1.PNG

View solution in original post

5 Replies
krishna_2644
Specialist III
Specialist III

yes you can.

See attached.

Capture1.PNG

Not applicable
Author

Hi Check Multi Colored check box here

Capture.JPG

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

krishna_2644
Specialist III
Specialist III

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

we have to input expressions .

Not applicable
Author

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

Not applicable
Author

Thanks a lot, it works