Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Graph Problem

Hello,

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

Here's my graph last January 2011

1.bmp

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

2.bmp

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
jonathandienst

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
Author

Hi Jonathan,

Where should I add

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

Thanks,

Salie

Not applicable
Author

Hi Jonathan,

Where should I add

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

Thanks,

Salie

jonathandienst

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
Author

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.

4.bmp

thanks a lot!