2 Replies Latest reply: Nov 30, 2016 12:54 PM by Nikos Volakakis RSS

    conditional in pivot table

    Nikos Volakakis

      Hi to all (really excited because I am really new to QlikView)

       

      I have created a pivot Table as you can see here

      qlik.jpg

      now I have a question:

      in the expression Stats (which is column (Correct)/(next column)) is there a way that I can keep only the result if the value is 1 and if not then there will be no result?

       

      Thank you all in advance