6 Replies Latest reply: Nov 9, 2015 8:01 PM by Shawn Ng RSS

    Right way to create a table without dimension

    Shawn Ng

      Hi, I want to create a table without dimension.

       

      Here is the problem, I have 3 tables, but because of the table dimension in qlik, I can't join them into 1 table.

       

      1st table dimension: month that users are created

      2nd table dimension: month that users drop out

       

       

      3rd table dimension: month that users signed up for program

      The reason I like to join them together because there I want to create secondary column (estimated active users & churn rate) using these primary columns

      So as you can see the problems

      1. 3 tables with 3 different dimension in qlik

      2. Not all 3 tables have value for every month, thus making the secondary column hard to compute

      3. Not sure how to implement the computation

       

      I have attach the sample in excel sheet. I would really appreciate any help, thanks.