topic Display text part of a Dual value when using the numeric part in QlikView

Display text part of a Dual value when using the numeric part

nickking — Fri, 20 Mar 2015 16:55:14 GMT

Hi Guys,

I have a bar chart that I would like to contain a reference line to separate work in progress bars from completed bars. To add the reference line to the dimension axis it needs to be set to continuous and use the Dual function to assign a numeric value to my text categories however when I do this it changes the Dimension Legends to the numeric value.

I would like to be able to use the numeric functionality but display the text values. Any ideas?

Thanks
Nick

Re: Display text part of a Dual value when using the numeric part

Anonymous — Fri, 20 Mar 2015 17:07:25 GMT

Something like this ?

Re: Display text part of a Dual value when using the numeric part

nickking — Mon, 23 Mar 2015 09:24:43 GMT

Hi Bill,

Thanks for the response. Unfortunately nothing was attached to your reply. Could I ask you to try again please?

Thanks very much

Nick

Re: Display text part of a Dual value when using the numeric part

Anonymous — Mon, 23 Mar 2015 09:35:53 GMT

Strange, can you see attached qvw this time ?

Re: Display text part of a Dual value when using the numeric part

nickking — Mon, 23 Mar 2015 09:52:55 GMT

Got it now Bill. Thank you. I think it was my fault. I was viewing it in my Inbox and didn't realise I had to click on the message title to see everything in your response. I have now found it and it works perfectly.

Thanks very much for your help (and speedy response both times)

Re: Display text part of a Dual value when using the numeric part

nickking — Mon, 23 Mar 2015 11:37:56 GMT

In trying to apply your solution I've noticed that the labels aren't sorting in the same order as the bars and nothing that I do fixes it. The labels in your solution are currently showing in the reverse order of the bars for some reason. Any ideas?

Thanks