Graph with X and Y axis in different tables

[hhajjali]

Hello,

I am new to qlik and need your help please!

I have 2 tables as follow:

Month
JAN
FEB
MAR
AVR
MAY

And the other table is as follow

ITEMS	IN	OUT
ITEM 1	JAN	MAY
ITEM 2	FEV	FEV
ITEM 4	FEV	MAR
ITEM 5	FEV	MAR
ITEM 6	MAR	MAY
ITEM 7	MAR	APR
ITEM 8	MAR	MAR
ITEM 9	MAR	MAY
ITEM 10	APR
ITEM 11	APR

I need to create a graphic which dimension will be Month and measures will be (1) count of month occurrence as IN, and (2) count of Month occurrence in OUT.

I tried the following function with no success:

if([MONTH]=[IN],Count([IN]))

Any ideas ?

Thanks in advance.

[luismadriz · Accepted solution]

Hi,

Few options, i hope it helps,

Cheers,

Luis

[hhajjali]

Thanks for your help!