Mini Chart lower bound issue

Tue, 06 Jul 2010 19:00:51 GMT

Hi, I'm using set analysis combined a Linear Gauge mini chart. However, I'm having an issue with the lower bound (i.e., if the value is less than zero, my chart will not draw). I was able to get the Max bound set using the following logic:

If(vComparePeriod = 'Year',
max(total aggr((Sum({$<FiscCalYr={'$(CurrentYear)'}>} ReportedPrice) / Sum({$<FiscCalYr={'$(PreviousYear)'}>} ReportedPrice)) -1, grpCGeoPartnerProduct)),
If(vComparePeriod = 'Quarter',
max(total aggr((Sum({$<FiscCalYr={'$(CurrentYear)'}, FiscCalQuarter={'$(vCurrentQtr)'} >} ReportedPrice) / Sum({$<FiscCalYr={'$(PreviousYear)'}, FiscCalQuarter={'$(vCurrentQtr)'} >} ReportedPrice)) -1,grpCGeoPartnerProduct)),
If(vComparePeriod = 'Month',
max(total aggr((Sum({$<FiscCalYr={'$(CurrentYear)'}, FiscCalMonth={'$(vCurrentMonth)'} >} ReportedPrice) / Sum({$<FiscCalYr={'$(PreviousYear)'}, FiscCalMonth={'$(vCurrentMonth)'} >} ReportedPrice)) -1, grpCGeoPartnerProduct)),
If(vComparePeriod = 'Week',
max(total aggr((Sum({$<FiscCalYr={'$(CurrentYear)'}, FiscCalWk={'$(vCurrentWeek)'} >} ReportedPrice) / Sum({$<FiscCalYr={'$(PreviousYear)'}, FiscCalWk={'$(vCurrentWeek)'} >} ReportedPrice)) -1, grpCGeoPartnerProduct))
)
)
)
)

How do I test for the lowest value instead of the highest value? I tried replacing "max" with "min" but it didn't work.

Mini Chart lower bound issue

Tue, 06 Jul 2010 20:06:47 GMT

I should mention that I tried hard-coding a fixed value & that still did not work. Any ideas what is causing this problem?

topic Mini Chart lower bound issue in QlikView

Mini Chart lower bound issue

Mini Chart lower bound issue