Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

kakaderanjit53
Contributor III

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

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:

Blank.PNG

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

Grey Blank.PNG

Thanks & Regards,

Ranjit Kakade.

Message was edited by: RANJIT KAKADE

Message was edited by: RANJIT KAKADE

Tags (1)
1 Reply
devarasu07
Honored Contributor II

Re: jjio