Qlik Community

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Support Case Portal has moved to Qlik Community! Read the FAQs to start exploring Support resources.
cancel
Showing results for 
Search instead for 
Did you mean: 
Naresh1
Contributor III
Contributor III

Qliksense pivot table colour

Hi all,

 I have pivot table in qliksense having 2 dimension and column and 2 measures

one dimension name is particulars, in particulars field having opening stock, closing stock , raw materials and total,...... 

i want show background colour for  these into blue colour remaining into light blue colour how can i write expression for this

please any one tell me

thanks,

1 Reply
msKarthikeyan
Employee
Employee

Hi Naresh,

You can try something like this 

=pick(Match(dim2,'cl_stock','op_stock'),Green(),Blue(),Yellow())

pivot_color.JPG

-Karthik