2 Replies Latest reply: Jan 6, 2018 3:54 AM by Haidar HAJ ALI RSS

    Graph with X and Y axis in different tables

    Haidar HAJ ALI

      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.