Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
There is no way to import textboxes.
If your month fields are strings you should be able to make dates from them using the date# function.
date#(MyField,'MMM-YY') as MyDate. That will turn a string Jan-12 into the date January 1st, 2012 (with numeric value 40909).
Thanks, I had tried a few variations, the problem turns out to be CrossTable transforms strings into text and this was not obvious. I had to create a second LOAD that converted text to numeric then apply Date.