topic Re: Grid chart aggregation error in QlikView

Grid chart aggregation error

Anonymous — Tue, 08 Jul 2014 15:08:17 GMT

Hi guys,

Please help me to fix my expression for first dimension.

I have expression with aggregation function, which gives me empty result.

Please find my attached file.

Thanks,

Re: Grid chart aggregation error

Greg_Williams — Tue, 08 Jul 2014 15:24:11 GMT

Vladimir - I have attached my app. Your calculation is working properly. You are unable to see the .01% element value associated with the third dimension item because the Y scale in comparison to the other plotted points (e.g. Orange, in this case) are so much larger.

Consider changing the Y Scale (Primary Axis numbers) manually in the Axes tab in Chart properties.

Greg

Re: Re: Grid chart aggregation error

Anonymous — Tue, 08 Jul 2014 15:38:32 GMT

Hi Greg,

But when I hide aggr expression from first dimension, the chart shows only 4 tags.

Please see my file.

Thanks, !

Re: Grid chart aggregation error

Anonymous — Tue, 08 Jul 2014 19:18:32 GMT

No ideas why or how???

Re: Grid chart aggregation error

Greg_Williams — Tue, 08 Jul 2014 20:05:44 GMT

I am using QlikView 11.20 SR6.

Re: Grid chart aggregation error

Anonymous — Tue, 08 Jul 2014 20:10:08 GMT

I'm using the same. I see 0.01, but when I remove aggr after Purchase horizon, it shows only 4 tags.

Re: Grid chart aggregation error

Greg_Williams — Tue, 08 Jul 2014 20:12:37 GMT

And your expression is the same as my expression - I moved the AGGR (slightly) - in my app.

Re: Grid chart aggregation error

Anonymous — Tue, 08 Jul 2014 20:17:09 GMT

Image from your app. still 5 tags

Re: Grid chart aggregation error

Greg_Williams — Tue, 08 Jul 2014 21:43:50 GMT

Other than:

1 - Turning on/off Suppression on both dimensions (almost like a reset/refresh),

2 - Rebuilding Chart from scratch to see if problem exists

3 - Removing zero value suppression in chart properties

4 - Increasing the width of your chart

5 - Formatting the numbers to fixed to 1-2 decimal spots

6 - Resizing the points in the Presentation tab

...not sure what else to try.

Re: Grid chart aggregation error

Anonymous — Wed, 09 Jul 2014 17:53:31 GMT

I found why it shows, because Purchase Horizon has 1 missing:

Other words Total respondents for Purchase Horizon 9117,

Total respondents for Consideration Stage 9118.

How can I remove tag, if one of them not answering?