7 Replies Latest reply: Nov 25, 2015 9:04 AM by Eduard Cabanas Gili RSS

    New Calculated field Pixel Perfect

    Eduard Cabanas Gili

      Hi

       

      My raw table coming from Qlik is:

       

      OrderId    Margin   Ispositive

      A             1            1

      B             2             1

      C             -1            1

       

      with this table I want to create a stack bar graphic to know the percentage the positive and negative orders, anyone knows how to create the Ispositive field? if(Margin <=0,0,1)

       

      Many thank's

       

      Eduard