topic Re: Dual values are shown as '#####' after SR 2 in QlikView

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

pennetzdorfer — Mon, 18 Mar 2013 08:06:40 GMT

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)

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

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

Anonymous — Mon, 18 Mar 2013 08:18:04 GMT

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 ######?

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

pennetzdorfer — Mon, 18 Mar 2013 08:34:00 GMT

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

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

Anonymous — Mon, 18 Mar 2013 08:38:27 GMT

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

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

Mon, 18 Mar 2013 08:53:58 GMT

Hi,

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

Regards,

Anju

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

pennetzdorfer — Mon, 18 Mar 2013 13:32:47 GMT

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

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

Tue, 19 Mar 2013 05:09:50 GMT

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

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

pennetzdorfer — Tue, 19 Mar 2013 07:18:17 GMT

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

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

Tue, 19 Mar 2013 07:31:03 GMT

Hi,

Can you please share your app?

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

pennetzdorfer — Tue, 19 Mar 2013 07:48:18 GMT

Of course!

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

Tue, 19 Mar 2013 08:26:11 GMT

Thank You!