Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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,
Hi Naresh,
You can try something like this
=pick(Match(dim2,'cl_stock','op_stock'),Green(),Blue(),Yellow())
-Karthik