Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
Can any one help me how to display duplicate records in front end.
tab1:
Id name
1 robert
2 john
innerjoin
tab2:
id lastname
1 jack
2 dev
1 ford
1 das
output is: id Name Last Name
1 robert jack
1 robert ford
1 robert das
now i need to see those 3 ones in front end please help me....
create a straight table chart with
dim
Id, name, lastname
expression
if(count(TOTAL <id> name)>1, 1)
you can hide the expression in presentation tab
You are using right inner join see the load script
tab1:
LOAD * Inline
[Id, name
1, robert
2, john
];
inner join
tab2:
load * Inline
[Id, lastname
1, jack
2, dev
1, ford
1, das
];
And on table box plot values
Id, name, lastname
And why you want to display only those 3 values.
tab1:
LOAD * Inline [
Id, name
1 , robert
2 , john
];
inner join
tab2:
LOAD * Inline [
id, lastname
1 , jack
2 , dev
1 , ford
1 , das
];
You can show data with a table or a chart (in this case add as expression the value 1)
Hi Alessandro
I Think There is no concept of right inner join in qlikview...
Add a expression field in a straight table - =RowNo()
create a straight table chart with
dim
Id, name, lastname
expression
if(count(TOTAL <id> name)>1, 1)
you can hide the expression in presentation tab
What do you mean with right inner join??
The instruction I gave to you is a inner join so only matching records on matching fields will be taken
Thank you Massimo.
Thank you all.
why dont you just concatenate id and lastname as calculated dimension and hide it