Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear Qlik Experts,
Attached is an app that I am testing. The pivot table has been color coded in the background.
However, when I click on the year selection, the color runs off, is there any way to make the color remains as it is?
The excel file is where the Qlik program is drawing the data from.
Try this for your color
=pick(num(Only({1}[impact pre]&[likelihood pre])),rgb(0,0,0), //ie 01
rgb(0,0,0),
rgb(0,0,0),
rgb(0,0,0),
rgb(0,0,0),
rgb(0,0,0),
rgb(0,0,0),
rgb(0,0,0),
rgb(0,0,0),
rgb(0,0,0),//10
...
Try this for your color
=pick(num(Only({1}[impact pre]&[likelihood pre])),rgb(0,0,0), //ie 01
rgb(0,0,0),
rgb(0,0,0),
rgb(0,0,0),
rgb(0,0,0),
rgb(0,0,0),
rgb(0,0,0),
rgb(0,0,0),
rgb(0,0,0),
rgb(0,0,0),//10
...
Hi Sunny,
This works perfect, thank you so much.