topic Re: Display X & Y-axis values in customized order in QlikView

Display X & Y-axis values in customized order

Anonymous — Wed, 25 Mar 2015 06:53:03 GMT

Hi All,

I've different charts in my .qvw file & I've created bar graph based on severity,

X-Axis is: Severity & Y-Axis is: 1 week,2 weeks and others ,the graph is working fine but the problem is X-Axis names are displayed in ASC order.

I've attached my sample graph for your reference.

I want DISPLAY names like LOW, MEDIUM,HIGH & CRITICAL? and How can i customize to display the names OR Values?

Wed, 25 Mar 2015 07:02:36 GMT

You can go to sort tab in chart and use expression for sort order.

Write an expression like if(severity='LOW',1,if(severity='MEDIUM',2)) like wise.

or you can create and inline table with two fields severity and num, give the order over there.

HTH

amay

Colin-Albert — Wed, 25 Mar 2015 07:07:49 GMT

Define your dimension for low, medium, high etc using the DUAL() function.

See this post for more details. Dual function