topic Graph Problem in QlikView

Graph Problem

Thu, 06 Oct 2011 15:49:50 GMT

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

Graph Problem

jonathandienst — Thu, 06 Oct 2011 16:09:05 GMT

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

Graph Problem

Thu, 06 Oct 2011 16:15:11 GMT

Hi Jonathan,

Where should I add

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

Thanks,

Salie

Re: Graph Problem

Thu, 06 Oct 2011 16:16:59 GMT

Hi Jonathan,

Where should I add

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

Thanks,

Salie

Graph Problem

jonathandienst — Thu, 06 Oct 2011 16:19:04 GMT

Salie

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

Regards

Jonathan

Re: Graph Problem

Thu, 06 Oct 2011 16:40:00 GMT

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!