Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Checking one field in another table?

Hi All,

I have two tables namely Open and Filled in which i have Open Positions and Filled Positions data respectively.

Now i need to show, Number open Positions(Req Number) from min(OpenDate) to selected year and it should check for it is Filled or not in the same time span.

I used the following exp

=count ({<Open.Status={'Open'},[Open.Opened Date]={"<=$(Year) "},Filled.Status={"<>$('Filled')"}>}DISTINCT [Req Number])

Please look at Attached app

the correct answer is if you select 2013 it should show 1 and if you select 2014 it should show 29 if you select 2015 or nothing it should show 87

12 Replies
Highlighted
MVP
MVP

maybe

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

{

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

-

<Filled.Status={Filled}>

}

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

Not applicable

It didnt worked like want we want want...

Highlighted
Specialist III
Specialist III

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

complete the data modelling first.

Thanks