This content has been marked as final. Show 2 replies
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?