topic Re: Qliksense modifying data in App Development

Qliksense modifying data

Tue, 19 Jul 2016 00:07:48 GMT

Hello,

I am puzzled with a Qlik Sense Desktop behaviour.

It happens on one of my PCs and not on another.

I have a table with:

WAREHOUSE:

LOAD * INLINE [

Code, Description

'06', "Room 06"

'R6', "Room R6"];

LOAD

Code as WH,

Description as Nome

RESIDENT WAREHOUSE;

DROP TABLE WAREHOUSE;

The resulting table is:

WH, Nome

06, Room 06

06, Room R6

On the other computer, the result is correct:

WH, Nome

06, Room 06

R6, Room R6

What computer configuration might be changing the data?

Thanks

Rui

Re: Qliksense modifying data

Gysbert_Wassenaar — Tue, 19 Jul 2016 12:13:47 GMT

What computer configuration might be changing the data?

None. This must be another error. Check that you didn't make a typo in the script. If you're really really sure that the exact same app behaves differently on two different machines then post that app here.

Re: Qliksense modifying data

Tue, 19 Jul 2016 16:15:05 GMT

Thanks Gysbert.

But I just found that this is a bug of Qlik Sense.

The PC with strange behavior has as Main setting for currency (it is in Brazil):

SET MoneyFormat='R$ #.##0,00;-R$ #.##0,00';

If I change to not have the R at the begining, it stops converting R6 into 06.

It seems that it is interpreting the $ as an wildchar.