8 Replies Latest reply: Jun 19, 2017 7:23 AM by Lukas Büdenbender RSS

    Flag in load script

    Lukas Büdenbender

      Dear all,

      I've got a problem with setting a flag in Qlikview load script.

      What I want to do is set a Flag to all Order Numbers where Sales(Income) is recorded.

      I've tried the following statement:

       

      NoConcatenate

      Fact_new:

      load *,

      if(rangesum(if(Cost.Element.MiKa='Sales',Actual))<>0 or rangesum(if(Cost.Element.MiKa='Income',Actual))<>0,'billed','not billed') as Billing.Indicator.Sales

      Resident

      Fact;

       

      Now I got a Flag to the Order Number with a recorded Sales and where Cost Element=Sales(Income). What I want to achieve is to set a flag to all order numbers where sales(income) <>0 regardless the cost element to show the CMIIa.

      Is this possible?

       

      Thanks in advance

       

      Lukas