Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Max limits in gauge trellis charts

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

1 Solution

Accepted Solutions
Not applicable

Re: Max limits in gauge trellis charts

Sorted.

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

4 Replies
goldnejea8
Contributor

Re: Max limits in gauge trellis charts

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

If(department='A', 3,

     If(department='B',4,

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

chauhans85
Esteemed Contributor

Re: Max limits in gauge trellis charts

in max Value

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

hope this helps

Not applicable

Re: Max limits in gauge trellis charts

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.

Not applicable

Re: Max limits in gauge trellis charts

Sorted.

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

Community Browser