2 Replies Latest reply: Aug 1, 2017 11:17 AM by Vineeth Pujari RSS

    Qlik Sense: Fetching data into fact table with filtered queries

    Michael Vaisgaard

      Hi,

       

      I want to be able to build a fact table in Qlik Sense, where I collect data from different data sources. When fetching data from the data sources I want to limit the queries to the base structure of my fact table to limit data to a minimum.

       

      Example:

       

      Base structure of fact table

      user_idname
      scjoScarlett Johansen
      brpiBrad Pitt
      tohaTom Hanks
      anjoAngelina Jolie
      madaMatt Damon

       

      Sales table

      user_idsales
      scjo553
      toha625
      anjo125
      brpi485

       

      Budget table

      user_idbudget
      scjo500
      brpi700
      toha300
      anjo

      150

      mada250

       

      Sales meetings table

      user_idmeeting_date
      brpi2017-01-20
      brpi2017-02-03
      toha2017-03-10
      anjo2017-03-22

       

      The source tables will in reality contain a lot of data on other user_ids, so I need to filter on only the employees in my fact table.

       

      How to do this?

       

      Hope you guys can help.