Qliksense pivot table colour

Naresh1 — Fri, 03 Apr 2020 07:10:33 GMT

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,

Re: Qliksense pivot table colour

msKarthikeyan — Fri, 03 Apr 2020 09:45:44 GMT

Hi Naresh,

You can try something like this

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

-Karthik