topic Highlighting Rows within a Straight Table in QlikView

Highlighting Rows within a Straight Table

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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!

Re: Highlighting Rows within a Straight Table

el_aprendiz111 — Wed, 25 Apr 2018 21:13:41 GMT

Hi,

1 expl:

Re: Highlighting Rows within a Straight Table

vishweshwarisun — Thu, 26 Apr 2018 06:22:32 GMT

Hi,

try this

In the background colour of that field

write the expression as :

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

Re: Highlighting Rows within a Straight Table

olivierrobin — Thu, 26 Apr 2018 07:09:03 GMT

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

Re: Highlighting Rows within a Straight Table

Anonymous — Thu, 26 Apr 2018 13:06:58 GMT

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.

Re: Highlighting Rows within a Straight Table

Anonymous — Thu, 26 Apr 2018 13:12:42 GMT

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.

Re: Highlighting Rows within a Straight Table

Anonymous — Thu, 26 Apr 2018 13:15:46 GMT

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.

Re: Highlighting Rows within a Straight Table

olivierrobin — Thu, 26 Apr 2018 13:22:53 GMT

in that case, you may try with aggr

something like that

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

Re: Highlighting Rows within a Straight Table

Anonymous — Thu, 26 Apr 2018 13:43:55 GMT

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?