topic Variable dimensions on x- and y-axis in QlikView

Variable dimensions on x- and y-axis

Fri, 21 Jan 2011 16:07:23 GMT

I guess this newbee questions was ask a hundered times - but I didn't find something. So the question:

I have a table with saledate, product, amount (per date/product).

I would like to have a linechart, where on the x-axis is the product, on the y-axis is a date vale. In the chart itself is the amount (accumulated for product/date).

Although there's a select box for product and date, the Linecahart should show selected products (or all) and selected date range, so both, x- and y-axis must be dynamic.

Is there some example or tutorial how to create this kind of chart?

Any help will be grateful

Tom

Addition:

I made a picture of what I'm thinking of:

But during outlining this I though this presentation would be to confusing to the viewer. So I guess a grid view will be a good solution.

Variable dimensions on x- and y-axis

Fri, 21 Jan 2011 16:21:25 GMT

Hi Tom ,

I dont think so you can do it using Line Chart but you can achieve it using Grid Chart.

Regards,

Chakravarthy.

Variable dimensions on x- and y-axis

johnw — Sat, 22 Jan 2011 01:43:49 GMT

The Y-axis in the chart you show isn't a product; it's a total amount for a product and month. Other than having labels next to the lines (which isn't supported), that makes it a simple two-dimensional line chart. Dimension 1 = salemonth, dimension 2 = product, expression = sum(amount).