Discussion board where members can get started with QlikView.
I have to produce a wallboard in Crystal Report, and it will be far easier for me to prepare the source information in QlikView.
Have a simple table, that lists sales order code, and a carriage charge.
Some of the sales order codes are text, but Crystal is importing the field as numeric.
Am using QlikView so create a CSV, that Crystal can them automatically import.
The field IS_DROPSHIP is Y or N, and I an trying to sort the outputted CSV so the Y is always listed first, which I can do below, but I can't figure out a way to then STORE the CSV file.
Hope that makes sense.
Any help would be appreciated thanks.
Resident Temp1 Order By IS_DROPSHIP asc;
store Temp1 into "---file.csv"(txt);
This script works, but the Order By is ignored