4 Replies Latest reply: Mar 1, 2017 4:14 AM by Giulio Andrea Toscano RSS

    Where is better to create new fields

    Giulio Andrea Toscano

      Hi All,

       

      my qlik sense application is very slow, maybe this happen because it is full of measures and dimensions created in the master item and not by script. My question is the following:

      "Is it possible that is more powerful to create complex dimensions and measures as field directly in the data load editor instead to create them in the master item? By creating all of them in the script the calculation time could be reduced?"

       

      Thanks,

       

      Giulio

        • Re: Where is better to create new fields
          Aehman K

          I'm not sure if this would help


          1. Extract the raw data from your data source and store them as qvd's

          2. Do the transformation by loading extracted qvd and store them as transform qvd's

          3. Load all your tables into one QVF file, which will be your Data Model file.

          4. Use your Data Model qvf file as Binary Load and do your designing in source file.

          5. Store big/complex expressions in variables.

           

          QVD's load faster and decrease the size of the file and it's better if they are optimized qvds.

          If it is still taking time to load then check with De bug mode available in your script to know where exactly it is taking time? It can also be due to number of rows you have in your data set.