6 Replies Latest reply: Dec 18, 2017 11:55 AM by carrie obrien RSS

    Apply Calculated Fields to Concatenated Data?

    carrie obrien

      Hello,

       

      I am new to Qlik, I am using the cloud version, and I am trying to understand if my use case is possible.

       

      I am creating visualizations for our services team and until I have the data available to me on a postgres server, I am using Excel files. I have an initial file of historical data and need to be able to concatenate new rows to the data on a weekly basis.  When I tried this, I was able to concatenate the data but the calculated fields that I created in the initial data set do not get applied to the new rows. Is there a way to have the calculated fields apply to each set of new data that I am adding?  It is the exact same column headers with each new file.

       

      Thank you!

      Carrie