Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

QlikView and Full Stops.

Hello,

I currently have two different orders and for this instance we will call it Order 123 and there is another order in the system with Order No 123. (with a full stop at the end). However, when I look in QlikView it is showing that there are two orders for 123 when in fact there aren't due to the full stop. Is there a way of getting around this?

Thanks in advance.

Andrew

17 Replies
Not applicable
Author

Okay here goes.

LOAD

     ORDER_NO&'_'&SITE as ORDER_KEY;

LOAD

     Text(ORDER_NO) as ORDER_NO,

     SITE

FROM database_table.qvd (qvd)

jonathandienst
Partner - Champion III
Partner - Champion III

Script:

LOAD Text(test) As test Inline

[

  test

  123

  123.

  0123

];

Output in list box with frequencies:

test.png

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
awhitfield
Partner - Champion
Partner - Champion

Hi Andrew,

the example attached is as per Stigchel‌ reply, just loading from a simple csv you end up with both 123 and 123.

What are you loading from, can you supply the SELECT part of the script? Is the . getting stripped out before it gets into QV?

Regards

Andy

jonathandienst
Partner - Champion III
Partner - Champion III

I expect the problem already exists in the qvd. The Text() needs to be in the original load from the database (in the qvd generator).

HTH

Jonathan

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
jpenuliar
Partner - Specialist III
Partner - Specialist III

Tell me, do you bleed? You will!

Not applicable
Author

Hi,

I'm loading straight from the database. It is Oracle, would that make a difference? This then gets put into the .qvd file.

Kind Regards

Andrew

awhitfield
Partner - Champion
Partner - Champion

"That's how it starts. The feeling, the powerlessness… that turns good men cruel"

awhitfield
Partner - Champion
Partner - Champion

Hi Andrew,

unfortunately I have no oracle knowledge at all, but if you execute the select statement in Oracle, does it actaull return the 123. ?