Grid chart aggregation error

[Anonymous]

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,

[Greg_Williams]

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

[Anonymous]

Hi Greg,

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

Please see my file.

Thanks, !

[Anonymous]

No ideas why or how???

[Greg_Williams]

I am using QlikView 11.20 SR6.

[Anonymous]

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

[Greg_Williams]

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

[Anonymous]

Image from your app. still 5 tags

[Greg_Williams]

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.

[Anonymous]

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?