topic Re: Max limits in gauge trellis charts in QlikView

Max limits in gauge trellis charts

Thu, 20 Sep 2012 15:12:37 GMT

Hi,

I've set up a trellis chart of 3 gauges, one for each department and I need to show how each is performing against the Sum(Budgets) for each separate department.

How can I effectively have a different max value generated for each department?

Hope this makes sense.

Thanks in advance,

Robin

Re: Max limits in gauge trellis charts

goldnejea8 — Thu, 20 Sep 2012 17:23:22 GMT

Try having an If..Then statement in the max value field.

If(department='A', 3,

If(department='B',4,

If(department='C',5')))

Re: Max limits in gauge trellis charts

SunilChauhan — Fri, 21 Sep 2012 04:15:12 GMT

in max Value

Sum(Budgets)* 1.2( taking 20% extra of sum)

hope this helps

Re: Max limits in gauge trellis charts

Fri, 21 Sep 2012 07:08:38 GMT

Thanks Sunil and Josh, but this won't work for me because the Sum(Budgets) gives me the combined total for every department (i.e. the entire company) whereas I need the each gauge to recognise which dimension (department) it relates to and then only calculate its max value as the budget for that single department.

Sorry if I didn't make this clear in the original post.

Re: Max limits in gauge trellis charts

Fri, 21 Sep 2012 08:09:51 GMT

Sorted.

I just changed my expression to show the percentage of budget met and this has worked OK.