Qlik Community

App Development

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

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
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