topic Re: selection new row in different table in QlikView

selection new row in different table

Anonymous — Tue, 05 Dec 2017 11:48:50 GMT

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

Re: selection new row in different table

felipedl — Tue, 05 Dec 2017 12:33:32 GMT

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.

Re: selection new row in different table

Anonymous — Tue, 05 Dec 2017 14:45:48 GMT

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

Thanks