8 Replies Latest reply: Aug 10, 2012 6:30 AM by At titude RSS

    Create flag expression from different tables

      Hi, I have a field called Income that I load from E:\qlikview\data\document1.qvd. I also have a field called Expenses that I load from E:\qlikview\document2.qvd.

      In the same script I want to create another field that acts as a flag if the Expenses surpass the Income. My script would go as follows:

       

      LOAD: ...

                 ...

                 Income_Hotel as Income,

                 ...

      FROM: E:\qlikview\data\document1.qvd

       

      LOAD: ...

                 ...

                 Expenses_Hotel as Income,

                 ...

      FROM: E:\qlikview\data\document2.qvd

       

      /*

      * Is there any way to do something like if(Expenses_Hotel>Income_Hotel, 1, 0)?

      */