topic How to display all values in a chart with no aggregation in QlikView

How to display all values in a chart with no aggregation

Fri, 08 Apr 2011 16:42:57 GMT

Hello,

I need to represent in a line chart Depth vs Costs. So Depth should be my dimension and I need two expressions for cost.

The problem is that I need every point in the chart, but I can´t doi it, because I'm being forced to represent just one point for each dimension value.

Can anyone help.

0		2073047,18
0	2439898	2082799,39
59		2486656,697
60	2485629
60	2492270
60	2802344
61		2604272,5
61		2694392,982
61		2745781,764
61		2940486,072
65		3005381,252
65	2816615
65	2829456

The result should be something like this:

How to display all values in a chart with no aggregation

Fri, 08 Apr 2011 17:03:52 GMT

Well please correct me if I am wrong... but you want to see 59,59,60,60,60 in place of 0,10,20,30,40 on the chart axis... If this is what you are trying to dont think you can do it normally... I mean QV sums up the values for common dimensions... its the standard functionality on any sheet object. If you want the sales for a month dimension it shows the sum(sales) for the whole month and if you want to see all then you can use a Straight table where you will see it... but i dont hink you can see it on the chart..sorry

ANDY

How to display all values in a chart with no aggregation

Anonymous — Fri, 08 Apr 2011 18:11:57 GMT

Instead of a straight table, you may want to look at a Table Box which is ideal to show the raw data. You may also include a rownum() in your load and include that as a dimension (you could even hide it in presentation tab) to truly avoid any aggregation..

Regards,

Dinesh.

How to display all values in a chart with no aggregation

Fri, 08 Apr 2011 18:48:35 GMT

I´ve already tried with the row number as a dimension but the chart shows each point a as different series

How to display all values in a chart with no aggregation

johnw — Fri, 08 Apr 2011 19:25:55 GMT

You can do it with a scatter chart instead of a line chart. See attached.

How to display all values in a chart with no aggregation

Fri, 08 Apr 2011 20:50:20 GMT

Thank you John, it's working perfect!