Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Highlighted
federik86
New Contributor III

selection new row in different table

Hi,

i've two straight tables with same columns but in the second one i've new record. I would to highlight those new record by color text or background.

Source code from sql db

Image example following

Thank you

1 Solution

Accepted Solutions
Partner
Partner

Re: selection new row in different table

Hi federico,

Using the following script:

table1:

LOAD * Inline

[

TABLE1

name1

name2

name3

name4

];

table2:

LOAD * Inline

[

TABLE2

name1

name2

name666

name676

];

left join (table2)

load

TABLE1 as TABLE2,

1 as [Flag TABLE1]

Resident table1;

Concatenate(table1)

Load

TABLE2,

[Flag TABLE1]

Resident table2;

drop table table2;

data:

Load

TABLE1,

TABLE2,

[Flag TABLE1],

if(not IsNull(TABLE2) and IsNull([Flag TABLE1]),1,0) as [Flag New Record]

Resident table1;

drop table table1;

You'll get the new records you want.

Attached the QVW I used and result on the below picture.

Sample.png

2 Replies
Partner
Partner

Re: selection new row in different table

Hi federico,

Using the following script:

table1:

LOAD * Inline

[

TABLE1

name1

name2

name3

name4

];

table2:

LOAD * Inline

[

TABLE2

name1

name2

name666

name676

];

left join (table2)

load

TABLE1 as TABLE2,

1 as [Flag TABLE1]

Resident table1;

Concatenate(table1)

Load

TABLE2,

[Flag TABLE1]

Resident table2;

drop table table2;

data:

Load

TABLE1,

TABLE2,

[Flag TABLE1],

if(not IsNull(TABLE2) and IsNull([Flag TABLE1]),1,0) as [Flag New Record]

Resident table1;

drop table table1;

You'll get the new records you want.

Attached the QVW I used and result on the below picture.

Sample.png

federik86
New Contributor III

Re: selection new row in different table

I cannot join two table, i should be work by dimension and expression formula.

Thanks