Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
MVP
MVP

Re: Checking one field in another table?

maybe

=count ( {$<[Req Number]=P(

{

<Open.Status={Open},[Open.Opened Date]={"<=$(=floor(yearend(makedate(max(Year)))))"}>

-

<Filled.Status={Filled}>

}

[Req Number])>}  DISTINCT [Req Number])

Highlighted
Not applicable

Re: Checking one field in another table?

It didnt worked like want we want want...

Highlighted
Specialist III
Specialist III

Re: Checking one field in another table?

Hy Nithin, you removed the syn key but u forgot to associate the tables.

complete the data modelling first.

Thanks