Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

hhajjali
New Contributor III

Graph with X and Y axis in different tables

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

ITEMSINOUT
ITEM 1JANMAY
ITEM 2

FEV

FEV
ITEM 4FEVMAR
ITEM 5FEVMAR
ITEM 6MARMAY
ITEM 7MARAPR
ITEM 8MARMAR
ITEM 9MARMAY
ITEM 10APR
ITEM 11APR

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.

1 Solution

Accepted Solutions
luismadriz
Valued Contributor

Re: Graph with X and Y axis in different tables

Hi,

Few options, i hope it helps,

Cheers,

Luis

Untitled.png

2 Replies
luismadriz
Valued Contributor

Re: Graph with X and Y axis in different tables

Hi,

Few options, i hope it helps,

Cheers,

Luis

Untitled.png

hhajjali
New Contributor III

Re: Graph with X and Y axis in different tables

Thanks for your help!