topic mini guage bounds in QlikView

mini guage bounds

Wed, 08 Jun 2011 03:15:59 GMT

Hello Experts ,

I have a issue regarding using expressions in mini guage charts ..,

I'm using mini guage in a straight box to display sum(Accounts) but in guage properties i want to give min & max values by expressions (not manually) and when i'm trying to declare them by expressions i mean for min =min(Sum(Accounts)) & max =max(Sum(Accounts)) it say's error in expression ...

So how can i declare values of min & max bounds of a mini guage by expressions ...

thanks a lot

Meher ...

mini guage bounds

Anonymous — Wed, 08 Jun 2011 03:33:42 GMT

Hi Merwan,

You can't use two aggregation functions like Max() or Min() and Sum() together like that. Not quite sure what you're trying to create. Do you have an example document to attach?

mini guage bounds

Wed, 08 Jun 2011 03:53:53 GMT

Yes Johannes but there must be some other aggr function to calculate these i'm searching for them but i'm not finding any ...

thanks a lot

Meher

mini guage bounds

Anonymous — Wed, 08 Jun 2011 04:07:37 GMT

Sure, there's always many ways of accomplishing things. Howeer, as I'm not sure what you're trying to do I'm unable to try and help. A .qvw example file would be good for illustrating what you want.

mini guage bounds

rwunderlich — Wed, 08 Jun 2011 07:04:42 GMT

Assume your dimension is Year. Set the max gauge property like:

max( TOTAL aggr(sum( Accounts), Year))

-Rob

mini guage bounds

Thu, 09 Jun 2011 00:36:53 GMT

Thanx rob it worked ...