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

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

Chanty4u — Wed, 25 Nov 2020 16:16:04 GMT

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.

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

Kushal_Chawda — Wed, 11 May 2016 07:10:40 GMT

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

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

Chanty4u — Wed, 11 May 2016 07:14:07 GMT

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

Kushal_Chawda — Wed, 11 May 2016 07:16:25 GMT

Sorry misunderstood in hurry. So how it is calculated?

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

marcus_sommer — Wed, 11 May 2016 07:20:51 GMT

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

- Marcus

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

Chanty4u — Wed, 11 May 2016 07:20:55 GMT

Hi Kushal,

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

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

Chanty4u — Wed, 11 May 2016 07:23:33 GMT

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.

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

Chanty4u — Wed, 11 May 2016 07:29:11 GMT

Please find the screen shots.

1st screen shot is before upgradation

2nd screen shot is after upgradation

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

marcus_sommer — Wed, 11 May 2016 07:30:30 GMT

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

sunny_talwar — Wed, 11 May 2016 08:48:00 GMT

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

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

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

Chanty4u — Wed, 11 May 2016 09:53:03 GMT

hi Marcus Sommer,

The issue got fixed. Thanks for your prompt response.

Can we know what has caused the issue. i mean the datatype to be changed.

We did not face this issue before the upgradation. The issue has come up only after the upgradation.

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

marcus_sommer — Wed, 11 May 2016 11:11:05 GMT

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