# New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

## Graph Problem

Hello,

Please help, I was wondering how to fix the graph below.

Here's my graph last January 2011

and here's my graph for this month. The scale is too high.

Here's the expressions I used

Static Max:

=ceil(max(aggr(sum([Volumes]),[MMM-YY])),   pow(10,len(textbetween(round(max(aggr(sum([Volumes]),[MMM-YY]))),'','',1))-2))

Static Step:

=ceil(max(aggr(sum([Volumes]),[MMM-YY])),   pow(10,len(textbetween(round(max(aggr(sum([Volumes]),[MMM-YY]))),'','',1))-2))/8

Thanks,

Salie

5 Replies
MVP

## Graph Problem

Salie

Have you checked to see what these subexpressions evaluate to?

max(aggr(sum([Volumes]),[MMM-YY]))

and

pow(10,len(textbetween(round(max(aggr(sum([Volumes]),[MMM-YY]))),'','',1))-2))

If you need to see what values are returned by the aggregation:

concat(aggr(sum([Volumes]),[MMM-YY]), ',')

Regards

Jonathan

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Not applicable

## Graph Problem

Hi Jonathan,

Where should I add

concat(aggr(sum([Volumes]),[MMM-YY]), ',')?

Thanks,

Salie

Not applicable

## Re: Graph Problem

Hi Jonathan,

Where should I add

concat(aggr(sum([Volumes]),[MMM-YY]), ',')?

Thanks,

Salie

MVP

## Graph Problem

Salie

Create a text box, and enter the expression in the text box. Put an = in front of the expression.

Regards

Jonathan

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Not applicable

## Re: Graph Problem

Hi,

I changed my expression to your expression. It worked. The only problem I have is that I need to show '50,000' after '45,000' to make it look complete.

I place the =concat expression you have provided on both Static Step and Static Max.

thanks a lot!