topic change axes in QlikView

change axes

yelin_nyu — Fri, 14 Jun 2013 15:49:27 GMT

normally you have sales qty and order qty by dates, a time trend view. now i want to create a chart where you are going to have sales qty and order qty on x-axis. qty on y, but break out lines by time. please see the mockup in attachment.

what do i put in dimension and expression?

Re: change axes

Gysbert_Wassenaar — Fri, 14 Jun 2013 16:38:09 GMT

That's not possible with a line chart afaik. The expression values will always be displayed on the y-axis.

Re: change axes

yelin_nyu — Fri, 14 Jun 2013 16:41:43 GMT

if line chart is not possible, is there any other chart that can do that? bubble chart? bar chart?

Re: change axes

Fri, 14 Jun 2013 17:17:25 GMT

You'd have to create a calculated dimension and a different expression:

Something like:

Dimension:

1. =ValueList('Sales Qty','Order Qty')

2. Month

Expression:

=pick(

Match(

ValueList('Sales Qty','Order Qty'), 'Sales Qty', 'Order Qty')

,sum( [Sales Qty] )

,sum( [Order Qty] )

)

Re: change axes

yelin_nyu — Fri, 14 Jun 2013 17:27:39 GMT

This look very helpful, is it possible for you to provide a test qvw? is ValueList() a function? I can't find it in help

Re: change axes

Fri, 14 Jun 2013 17:34:45 GMT

Here you have. I don't know why but the valuelist function doesn't appears in help. I think there is a description about it in the QlikView Desktop manual.

Re: change axes

yelin_nyu — Fri, 14 Jun 2013 17:37:22 GMT

This is awesome. love it. Thank you!!!