Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
pennetzdorfer
Creator III
Creator III

Dual values are shown as '#####' after SR 2

Our IT department has installed Service Release 2 this weekend. Since then all listboxes containing "dual values" are shown improperly: values that exceed listbox width are shown as '#####' (Mouseover-tooltip works though)

test.jpg

Script definition for 'Region' is:

dual(RegionNumber & ': ' & RegionName, RegionNumber) as Region

Listboxes with an expression like text(Region) are shown properly ... so, it seems that only dual fields are affected.

Any help is much appreciated!

Regards,

Florian

1 Solution

Accepted Solutions
pennetzdorfer
Creator III
Creator III
Author

Using text() kills the idea of dual fields   It removes the big advantage of chosing string or numeric presentation.

Obviously there's a bug in displaying dual fields ... please see http://community.qlik.com/message/323012

As a workaround I'm using text(Region) in the listbox together with num(Region) for sorting ... as proposed by brianjmclean.

Regards,

Florian

View solution in original post

10 Replies
Anonymous
Not applicable

Hi Florian,

Does it work correctly if you try:

dual(Text(RegionNumber & ': ' & RegionName), RegionNumber) as Region

Or will QlikView still cut off your long values and give you ######?

pennetzdorfer
Creator III
Creator III
Author

Johannes, thanks for the idea ... but that doesn't work either. See attached file.

Anonymous
Not applicable

Hm, a quick workaround would be to use =Text(Region) as a listbox expression. Should work fine.

Not applicable

Hi,

Try expanding the List Box itself. It is displayed fine then.

Regards,

Anju

pennetzdorfer
Creator III
Creator III
Author

Anju, you're right - but for design reasons I can't expand all dual field listboxes.

Long values should be simply cut off ... mostly that will be enough for the user. If not, we've still got the mouseover tooltip.

Regards,

Florian

Not applicable

Hi Florian,

Did you try this?

load text(dual(text(RegionNumber & ': ' & RegionName),RegionNumber)) as Region inline [

    RegionNumber, RegionName

    10, TestRegion123

    20, TestRegion456

    30, TestRegion789];

Even this works!

load text(dual(RegionNumber & ': ' & RegionName, RegionNumber)) as Region inline [

    RegionNumber, RegionName

    10, TestRegion123

    20, TestRegion456

    30, TestRegion789];

Regards,

Anju

pennetzdorfer
Creator III
Creator III
Author

Using text() kills the idea of dual fields   It removes the big advantage of chosing string or numeric presentation.

Obviously there's a bug in displaying dual fields ... please see http://community.qlik.com/message/323012

As a workaround I'm using text(Region) in the listbox together with num(Region) for sorting ... as proposed by brianjmclean.

Regards,

Florian

Not applicable

Hi,

Can you please share your app?

pennetzdorfer
Creator III
Creator III
Author

Of course!