Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Qliksense modifying data

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

1 Solution

Accepted Solutions
Not applicable
Author

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.


View solution in original post

2 Replies
Gysbert_Wassenaar

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.


talk is cheap, supply exceeds demand
Not applicable
Author

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.