Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
federik86
Contributor III
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
felipedl
Partner
Partner

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

View solution in original post

2 Replies
felipedl
Partner
Partner

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

View solution in original post

federik86
Contributor III
Contributor III
Author

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

Thanks