Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
Chanty4u
Esteemed Contributor III

Age element which has + sign moved from left to right position

Hi All,

We have upgraded our dev environment to 2.2.3 from 2.0.3. After this upgradation we are seeing the Descriptive age elements have moved from left to right position.

Example: Its behaving as the same as below.

18+

65+

          18+

          65+

Had anyone faced this issue.

1 Solution

Accepted Solutions
MVP & Luminary
MVP & Luminary

Re: Age element which has + sign moved from left to right position

Normally will a datatype and it's format be interpreted from the first record of this field and if there are changes (per different sorting or filtering or other script-changes) it could be that the interpretation is different then before. Possible is also that qv had changed the functionalities by the interpretation - maybe there is a note within the release notes.

- Marcus

11 Replies

Re: Age element which has + sign moved from left to right position

I think it's downgraded.  How this is calculated?

Chanty4u
Esteemed Contributor III

Re: Age element which has + sign moved from left to right position

Hi Kushal,

This is upgraded from 2.0.3 to 2.2.3 version

Re: Age element which has + sign moved from left to right position

Sorry misunderstood in hurry. So how it is calculated?

MVP & Luminary
MVP & Luminary

Re: Age element which has + sign moved from left to right position

It looked that the datatype changed from string to numeric. Have you any issue with this change?

- Marcus

Chanty4u
Esteemed Contributor III

Re: Age element which has + sign moved from left to right position

Hi Kushal,

It is coming from a table which has a datatype varchar(50).

Chanty4u
Esteemed Contributor III

Re: Age element which has + sign moved from left to right position

Few of the elements as string and appear on the left side in the filter pane. And other few are appearing on the right side.These have '+' sign.

Chanty4u
Esteemed Contributor III

Re: Age element which has + sign moved from left to right position

Please find the screen shots.

1st screen shot is before upgradation

2nd screen shot is after upgradation

MVP & Luminary
MVP & Luminary

Re: Age element which has + sign moved from left to right position

I think I would load these field in this way:

dual(num(keepchar(AGE, '0123456789')) & '+', num(keepchar(AGE, '0123456789'))) as AGE

but you couldn't do this directly within a SQL statement - you will need a preceeding load or a resident load for it.

Edit: with your new details I wouldn't do the dual() else I would load this field with text().

- Marcus

Re: Age element which has + sign moved from left to right position

You can always fix the alignment of a particular field from the document properties. This would change the alignment for Multibox and List box throughout the application

Capture.PNG

Select Left for both Text and Numbers and that would give you left oriented field.