topic Segment Boundaries in QlikView

Segment Boundaries

Thu, 23 Feb 2012 19:00:01 GMT

I created a (guage) chart. The dimension is setup as follows, =if([Sales Comp]='WES' or 'DST' or 'DTO', [Sales Comp]). The expression is Pounds Shipped, Sum([QTY Shipped LB])/1000.

The MAX guage setting is Sum([QTY Budget]/1000)

The Segment 2 lower boundary is Sum([QTY Budget]/1000)*Threshold.

The Segemnt 3 lower boundary is Sum([QTY Budget]/1000).

The issue is the boundaries and major units on the gauge are for all values of [Sales Comp] and not the ones selected in the dimension. Segement 2 should be 400, segement 3 should be 470 and the Pounds Shipped 670.

Thanks for your help.

Segment Boundaries

jagan — Fri, 24 Feb 2012 05:23:40 GMT

Hi,

Can you attach the sample.

Regards,

Jagan.

Re: Segment Boundaries

Fri, 24 Feb 2012 13:40:31 GMT

I can't send a sample .qvw because the data is proprietary. Hopefully the attachment will help with the explanation. Thanks.

Regards,

Frank

Segment Boundaries

jagan — Fri, 24 Feb 2012 14:56:10 GMT

Hi,

In Gauge chart dimension should not be given, even if you give it is not considered. Can you attach the sample with some sample data.

Regards,

jagan.

Segment Boundaries

Fri, 24 Feb 2012 18:40:50 GMT

I have uploaded a sample. Please take notice that the upper limit on the charts is 608 which represents the total Target Volume. I’m dividing everything by 1000 for clarity on the chart. I would like the upper limit to be the Target Volume on the individual sub cores. Thanks.

Re: Segment Boundaries

jagan — Sat, 25 Feb 2012 05:39:05 GMT

hi,

I created a chart in your attached file, please check that is what you required, if not please let me know what you want clearly.

Regards,

Jagan.

Re: Segment Boundaries

Mon, 27 Feb 2012 16:12:28 GMT

Jagan,

In the chart you created I would like the upper limit to be 1356 which is the target for New Zealand Dairy. The chart is showing 607 which is the sum of all the target volumes.

I have an alternative solution that I'm working on using the percentage of the tartget achieved. This keeps the scale the same for all categories. Thanks.