Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Hi,
Few options, i hope it helps,
Cheers,
Luis
Thanks for your help!