How to restrict the colour in the Straight Table for Specific rows??

[kakaderanjit53]

Hi Qlik Experts,

I have created a Qliksense dashboard by using Straight table,In which specific row are coloured based on rowtype dimension,

But after selection of filters colour of the same rows are disappearing and by default colour assigned to the alternative records are displaying for all rows,how to overcome such issue,I have to keep constant "white" colour for Blank Rows and I have placed Blank rows with spaces for avoiding zeros in the same rows but after filter selection Zeros are occurring in the Blank rows,Im using following expression for BG-colour ;

i.e.. for E.g. Actual field , expression for BG-colour is

if(WildMatch(RowType,'Blank')>0,white(),

if(MagCategoryName='',white(),

RGB(255,255,153)))

PFB screenshot for more details:

1. Before filter selection:

2. After Filter Selection:Blank rows colour changes white to grey and Zeros are appearing in blanks rows;

Thanks & Regards,

Ranjit Kakade.

Message was edited by: RANJIT KAKADE

Message was edited by: RANJIT KAKADE

[devarasu07]

How to get answers to your post?