Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
Sra1bandi
Contributor III
Contributor III

how to write expression based on status in two tables

Hi Team,

I have two tables with different data with one primary key 

 

TABLE1:-

load* ,inline[

Id ,  Wf_Status

1,     Closed

1,    open]

 

Table2:-

load* ,inline[

Id ,  TK_Status

1,     Completed

1,     Completed

1,    Started

1,    ready

1,    Committed]

 

My required table is 

in 1st table when i filter with Wf_status='Open'

in 2nd table i need to exclude TK_Status='Completed' need to show other three values.

Output  data====>

 

Table1:

Id      Wf_Status 

1        open

TBLE2:

id     TK_Status

1         Started

1        ready

1        Committed

 

Regards,

Sravan.

 

Labels (1)
4 Replies
BrunPierre
Partner - Master
Partner - Master

@Sra1bandi As below.

Table2:
load * inline[
Id , Wf_Status
1, Closed
1, Open ]
Where Match(Wf_Status,'Open');

Table2:
load * inline[
Id , TK_Status
1, Completed
1, Completed
1, Started
1, ready
1, Committed ]
Where Match(TK_Status,'Completed') = 0;

sidhiq91
Specialist II
Specialist II

@Sra1bandi  You can try something like below too:

NoConcatenate
Table2:
load * inline [
Id , Wf_Status
1, Closed
1, Open ]
Where Match(Wf_Status,'Open');

NoConcatenate
Table2:
load * inline [
Id , TK_Status
1, Completed
1, Completed
1, Started
1, ready
1, Committed ]
Where not Match(TK_Status,'Completed');

Exit Script;

Sra1bandi
Contributor III
Contributor III
Author

Hi Both

Thanks for reply but i need in front end not in back end 

i have two tables 

i need to show all data 

when i select open cases in table then only i need to apply above mentioned conditions 

Reagrds,

Sravan.

BrunPierre
Partner - Master
Partner - Master

In that case, use Wf_Status and TK_Status fields as filter panes/list boxes?