2 Replies Latest reply: Feb 18, 2013 12:02 PM by Simon Goodman RSS

    Excel, CrossTables

    Simon Goodman

      I have an excel document as the data source with a number of sheets each setting several blocs of data horizontally. So I have been using the Transformation and CrossTable to prepare data for Qlikview.

       

      My first problem or question is there a way of importing textboxes?

       

      My second relates to dates. Sorry if this seems both simple to resolve and obvious. Each sheet has month fields e.g. Jan-12. I have used Load * to take account of new monthly related data and QV shows them as numbers. I have unsuccessfully tried various formatting solutions in the document. Is there a script solution or do I need an expression in each table/chart?