Variable min and max gauge chart

Thu, 13 Jun 2013 18:53:11 GMT

Trying to assign variable min and max value to a gauge chart, and show the employer selcted accordingly on the graph.

To explain in detail: using an expression to calculate the percentage of families for each employer within a topic category.(expression works right can see the values in a pivot table).

Would like to assign the minimum and maximum percetage values to Gauge chart, and when a employer is selected should allign accordingly to the min and max values.

variable:

=Count(DISTINCT familyid)

Count(total<Employer> DISTINCT familyid)

expressions for min and max: min(variable), max(variable)

Also tried aggr: =max(aggr(sum(variable),familyid))

Thanks in advance.

Re: Variable min and max gauge chart

Thu, 13 Jun 2013 19:06:05 GMT

I don't see the problem with your idea. I think I did once something like you want. In the attached picture you can see that I use a variable to set the max gauge limit and also, the inner segments boundaries are defined with this variable.

topic Re: Variable min and max gauge chart in QlikView

Variable min and max gauge chart

Re: Variable min and max gauge chart