8 Replies Latest reply: Jul 21, 2010 9:33 AM by umangu2000 RSS

    Help with displaying whole numbers

    Chris Hopkins

      Hi,

      I have a straight table with an expression which basically just divides SALESQUANTITY by 3. I would like QLIKVIEW to only display the results for this expression if they are whole numbers, i.e.

      If the results show

      1.333

      .333

      4

      2

      .333

      I only want the 4 and 2 to be displayed and the others hidden.

      Is this possible?