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

    Determine the values [Cross Table]



      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.