7 Replies Latest reply: Mar 6, 2017 10:10 AM by Lauren Mills RSS

    How to Edit Script

    Lauren Mills

      I have 5 different SQL summaries feeding my dashboard.

       

      They all join to each other (on different fields) so I can have my data set.

       

      How and where would I write in a IF statement - would I create a new section at the end of the 5 SQL summaries?

       

      Any ideas would help.

        • Re: How to Edit Script
          Shahbaz Khan Mohammed

          You want to create new fields in script using IF statement?

           

          If yes, then I believe you'd have to either do preceding load or resident load (separate table with one common key joining your 5 table(one fact).

          If preceding load then before your load statement, take the field name you suppose to modify and create a new field.

           

          I'd rather first join all the tables as a raw extract table into one fact, store that into QVD (check fact table name, usually the Fact will be created based on your First Table Name)

          Load the fact QVD, do preceding load to Qlik script using IF statements.

           

          I'm talking about Qlik Scripting, not SQL script (which I've no idea about)

          Consume SQL script, store into qvd, consume qvd, transform it. Much simpler I guess.

          Experts might disagree

          • Re: How to Edit Script
            Lauren Mills

            If Match Statement

             

            ^ Question Answered Here