Limiting a Field in a Chart

Fri, 06 May 2011 18:22:52 GMT

I am trying to make a chart based on a field in my database where I want to have the chart graph all records with a value of 70% or greater. I have tried the formula two ways the first in a calculated dimension then as an expression. In both cases I get an error in the calculation...=sum(Opportunity.Probability) > 70

Any Advice?

Limiting a Field in a Chart

Oleg_Troyansky — Fri, 06 May 2011 19:37:56 GMT

You need to determine what dimension are you trying to limit by this condition, and use it in Set Analysis. For example, if you are counting OpportunityID with the sum(Probability) > 0.7 , you should have an expression like this:

count({<OpportunityID={"=sum(Opportunity.Probablility)>0.7"}>} distinct OpportunityID)

Notice that your condition serves as a search condition for the field that you want to limit (OpportunityID in this example)

topic Limiting a Field in a Chart in QlikView

Limiting a Field in a Chart

Limiting a Field in a Chart