topic Re: Dual Function Lost if add symbol in numeric format in QlikView

Dual Function Lost if add symbol in numeric format

derekjones — Wed, 01 Mar 2017 09:59:00 GMT

I've just encountered this from upgrading to Qlikview 12, however I've also tested back in 11.2 and it's also occurring now.

In a bar chart, you can use a dual expression to have the bar represent one value and then the text ontop of the bar chart represent another value.

In my simple example, I've created an expression for the bar to be 'Revenue' and the text ontop of the bar to be 'Margin'..

=dual(num(avg(Margin/100),'#.#0%'),sum(Rev))

Without numeric formatting e.g. £k or £m, the bar chart behaves itself. As you can see below, the value ontop of the bar is the margin in % i.e. 3.20%. However the y axis is messy as it's showing in single £'s..

So I now set the numeric format under the number tab to put £k..

Now the graph loses it's dual functionality and shows the Rev value ontop..

Is this a bug?

Sample qvw attached.

Thanks in advance for any assistance.

Re: Dual Function Lost if add symbol in numeric format

sunny_talwar — Wed, 01 Mar 2017 11:08:21 GMT

Seems like it...

Re: Dual Function Lost if add symbol in numeric format

derekjones — Wed, 01 Mar 2017 11:38:59 GMT

Okay, if it is a bug, does anyone know how I log this with Qlik?

Re: Dual Function Lost if add symbol in numeric format

sunny_talwar — Wed, 01 Mar 2017 11:42:33 GMT

Old discussion, but see if this link helps:

How to report a bug? | Qlik Community

Re: Dual Function Lost if add symbol in numeric format

Peter_Cammaert — Wed, 01 Mar 2017 12:05:21 GMT

IIRC your original goal is usually accomplished by defining two expressions, of which one simply displays a value (in % in your case) and not a bar. The advantage then is that you can format the second expression as you like, while the first one displays bars and axis values according to you number specification.

A solution using a single expression will get messy (or schizophrenic) sooner or later...