Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Mini Chart lower bound issue

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.

1 Reply
Not applicable
Author

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