topic Re: Caption field reversed the transition between the development environment and the browser in QlikView

Caption field reversed the transition between the development environment and the browser

Sun, 29 Nov 2015 12:51:26 GMT

During the development of one of our models, we have a situation where the string concatenation that contains three fields in the data presented at Bays (SQL) correctly,

After pulling in circulation through the steps QVD -> ETL model QVW also normal. In addition to the display of WEB VIEW development environment displays the data correctly.

The transition to the external server browser when you enter the string model is reversed and displays the data incorrectly (the phenomenon occurs Chrome and Internet Explorer browser, not including IE 11).

I tried all I see fit to handle it but I can not.

I would be delighted if someone here has a solution for this kind of case.

P.S

The string is a combination of words in Hebrew, numbers separated by "|"

I've included screenshots showing what happens thread between different environments.

Includes the settings and the process of linking SQL phase.

The field comes into the QlikView field as NCHAR.

The string sould look like this"

YEAR||NAME(In Hebrew)||Number ‏1-||פורים||‏2013

Thank you very much in advance,

Doron

Re: Caption field reversed the transition between the development environment and the browser

petter — Sun, 29 Nov 2015 19:05:44 GMT

Could you please show how it is done in your Load Script and how it is done in your expressions in the UI?

The fragments of screenshots are barely readable and not very informative of the context - so it is hard to guess at what you are doing where...

The SQL doesn't matter much - but the concatenation you do in your load script and or in your UI in your charts or variables DO.

Re: Caption field reversed the transition between the development environment and the browser

Sun, 29 Nov 2015 20:05:56 GMT

Hi Petter

I've included a number of new images that illustrate more clearly the process, from the database to the phase inversion of the data in the

browser.

Thank you very much for helping.

Doron

1. Sql DataBase:

2. DbToQvd

.The ETL Load The FIELDS From The TIME QVD Above

Time:

LOAD [Year],

[QV_Holiday_Code],

[QV_Holiday_Name_Heb],

[QV_Holiday_Name_Eng],

[Year_Holiday_Key],

[Year]&'|'&[QV_Holiday_Name_Heb] as Holiday_Year,

[QV_Period_Code],

[QV_Period_Name_Heb],

[QV_Period_Name_Eng],

[QV_Period_Desc_Heb],

[QV_Period_Desc_Eng],

Text( Holiday_Year_Period)AS Holiday_Year_Period, (Try to change the format )

Holiday_Year_Period1,

Holiday_Year_Period2,

Text( Holiday_Year_Period3 )AS Holiday_Year_Period3,

4.Dev QVW Looks ok

The display changing the direction of your browser

Re: Caption field reversed the transition between the development environment and the browser

Tue, 01 Dec 2015 13:36:47 GMT

Hello everyone,

Someone may have encountered a similar problem?

Thanks.

Re: Caption field reversed the transition between the development environment and the browser

Tue, 01 Dec 2015 13:40:22 GMT

Hi Petter

I've included a number of new images that illustrate more clearly the process, from the database to the phase inversion of the data in the

browser.

Thank you very much for helping.

Doron