topic Re: Separation failure TTX-files in QlikView

Separation failure TTX-files

Thu, 02 Aug 2012 10:51:26 GMT

Hi,

For the organization I'm working for I want to analyze auction figures. The files are in TTX and can be read by Qlikview.

When I change the separation from ";" (semicolon) to "\t" (tab) Qlikview automatically changes it back to the semicolon. Even if the change (' \t ') is mentioned in the script. How can I force Qlikview to pick the "tab" seperation?

Thanks in advance

Re: Separation failure TTX-files

Thu, 02 Aug 2012 13:03:48 GMT

post a sample of your txt file:)

Re: Separation failure TTX-files

Thu, 02 Aug 2012 13:10:49 GMT

Hi,

Hereby a sample file.

P.s. it's really an TTX-file (Used for reading auction (flowers) numbers)

Re: Separation failure TTX-files

Thu, 02 Aug 2012 13:15:45 GMT

how you create your script? by wizard?

Re: Separation failure TTX-files

Thu, 02 Aug 2012 13:20:41 GMT

Hi Pari Pari

I've created the script without the wizard, I've directly add the files to the script.

Re: Separation failure TTX-files

Thu, 02 Aug 2012 13:22:18 GMT

are you sure you've got:

(txt, codepage is 1250, embedded labels, delimiter is '\t', msq);

Re: Separation failure TTX-files

Thu, 02 Aug 2012 13:27:23 GMT

This is what I got:

(txt, codepage is 1252, embedded labels, delimiter is '\t', msq);

Still, after reloading, it says: '\t' but uses ';'

Re: Separation failure TTX-files

Thu, 02 Aug 2012 13:29:24 GMT

i can't find ";" in your txt file:)

Re: Separation failure TTX-files

Thu, 02 Aug 2012 13:40:07 GMT

That's correct , me neither .

After looking at it again it's not using the ';' command but still I can't use formulas with the numbers I've got.

Thanks for your time, it must be some other failure.

Re: Separation failure TTX-files

Thu, 02 Aug 2012 13:45:04 GMT

which formulas cant you use?

Re: Separation failure TTX-files

Thu, 02 Aug 2012 13:57:47 GMT

Hi,

I've figured that I need to mark the "Load all" function in the script-editor, otherwise Qlikview isn't loading the right figures. I want to use a simple turnover formula (price multiplied with pieces sold). In the example that are title 14 (price) and 337 (pieces).