Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

sridhar423
New Contributor III

App development

Hi All,

I have two tables.I loaded the two tables ,after concatenating i have a table that consists of Lotno and Prod.Actually Lotno 1 has two Prod A and D.But when i select  "1"  i need to get the Prod A only.if the two tables contains same Lotno priority should be given to Table1 only.

        Table1 

        

LotnoProd
1A
2B
3C

    Table2

              

LotnoProd
1D
3E
5F

Thanks

Sridhar.

Tags (1)
3 Replies
Highlighted
bhagirath
Contributor III

Re: App development

Hi Shridhar,

Attached is a sample app for solution

sridhar423
New Contributor III

Re: App development

Hi Bhagirath,

I saw ur attachment but it is complex.After some trials i got the solution.

By using Exists function we can get the answer what i post in the earlier one.

try using Where not exists.

Thanks

Sridhar.

bhagirath
Contributor III

Re: App development

mine was one of the solutions and not the only solution.