Qliksense pivot table colour

[Naresh1]

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,

[msKarthikeyan]

Hi Naresh,

You can try something like this 

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

-Karthik