15 Replies Latest reply: Jan 6, 2016 1:39 AM by Nathaniel Anderson RSS

    Determine the values [Cross Table]

      *Edited*

       

      Hello and Good Day!

       

      Since I am new at using qlikview, I find it hard to analyze what should be my steps when cleaning an excel file. I have

      an idea of using crosstables when encountering this kinds of problems.

      attached file is the excel file.

       

      What I need:

      1. To know if it is under what year.

      2. To know if it is under Revenue or Visitors

      3. To know what is public or private


      Thank you.