Highlighting Rows within a Straight Table - Qlik Community

Anonymous · ‎2018-04-25

I am trying to highlight rows within a straight table that share the same id number.

For example I have the following data columns in my table:

Id Date

12 4/1/2018

123 4/12/2018

11 3/30/2018

34 6/30/2017

12 8/18/2016

56 1/3/2017

The id number 12 appears twice....ideally I would like the table to be shown as below. Is there a way to do this?

Id Date

12 4/1/2018

123 4/12/2018

11 3/30/2018

34 6/30/2017

12 8/18/2016

56 1/3/2017

Many thanks!

el_aprendiz111 · ‎2018-04-25

Hi,

1 expl:

vishweshwarisun · ‎2018-04-26

Hi,

try this

In the background colour of that field

write the expression as :

=if(Id='12',Yellow())

olivierrobin · ‎2018-04-26

hello

create another table couting the number of time each Id appears

join it to the 1st one

and use conditional expression in bakground color like ;

if (NbrOfTimes>1,blue(),black())

for example

Anonymous · ‎2018-04-26

Thanks for the reply Vishweshwari! Much appreciated!

If the table was static, this logic would apply, but it is dynamic. There is potential for multiple ids to have duplicate rows and the id will not always be equal to 12. I am trying to come up with some type of script that will look at the current id column displayed in the straight table based off of various list box selections....and then apply the conditional highlighting formatting to applicable rows.

Anonymous · ‎2018-04-26

Thanks for the reply Olivier!

If my table was static, your suggestion would definitely work. I failed to mention in my original post that there are various list boxes associated with the straight table, and based on the selections of the end user the table is constantly changing. I am hoping to have a conditional formatting applied to only the ids visible in the table after list box selections are made.

Anonymous · ‎2018-04-26

Thanks for the reply Jairo!

The id number will not always be equal to a just one value, I failed to make that distinction in my original post. I need it to look at all the ids displayed in the straight table, and apply a condition highlighting format to the entire row.

olivierrobin · ‎2018-04-26

in that case, you may try with aggr

something like that

if(aggr(count(Field),id)>1,blue(),yellow()

Anonymous · ‎2018-04-26

I added the if(aggr(count(Field),id)>1,blue(),yellow() statement....and technically it is working.

Id #571 appears multiple times within the data used to generate the table, but based off of list box criteria selections only one row for #571 applied. Is there a way to update the statement and limit it to only look at id numbers that appear in the straight table based off of current selections?