topic Re: Dual value display in List Boxes and charts in QlikView

Dual value display in List Boxes and charts

Mon, 05 Nov 2012 09:35:42 GMT

In QV11 SR2 Dual values that have 'long' text representations are displayed as '#####' instead of the usual truncation of the text value using '...' (e.g. "Long text repr...")

This was a problem in QV10, but was fixed in a later SR and was not a problem on QV11 until now. Has anyone else experienced this? It's creating chaos from the display of my QV11 models.

Thanks,

Brian

Re: Dual value display in List Boxes and charts

Tue, 06 Nov 2012 12:10:23 GMT

After reinstalling QV11 SR1 I can confirm that SR1 did not use the '...', but did allow the text to simply display as many characters as possible.

SR2 shows '#####', obliterating the text altogether.

Is anyone else having this issue? Any suggestions on how to fix it?

Thanks,

Brian

Re: Dual value display in List Boxes and charts

Wed, 07 Nov 2012 11:06:39 GMT

So as it turns out the change in behaviour from SR1 to SR2 as described above is a big fix.

According to the release notes for SR2 this bug has been fixed:

46813: Too long tables are not displayed with # in tables.

Please help me here - why is it better to display '#####' instead of a readable truncated value?

(Thanks John Houston for pointing the bug fix out!)

Re: Dual value display in List Boxes and charts

Thu, 08 Nov 2012 07:16:24 GMT

I'm working around this problem by putting an expression into the list boxes and a calculated dimension on the charts that does a Text() on the dual. Then the sort requires an expresion using the dual value.

This is a lot more clunky than the previous behaviour which handled this more gracefully.

Re: Dual value display in List Boxes and charts

pennetzdorfer — Mon, 18 Mar 2013 08:48:54 GMT

Hey Brian,

I'm facing the same problem!

http://community.qlik.com/message/323007

Any news on that?

Regards,

Florian