Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
tuftonmc
Contributor III
Contributor III

Minimum Value Across Range of Data Set

I have simple line charts which shows prices and unit costs as the expressions and date as the dimension.

Assuming the date range is between 1st Jan 2014 and 1st June 2014. The chart is over this period.

I want to show the minimum unit costs reached between the 1st Jan and the current date in the line chart.

On the 1st Jan 2014 all three values would be the same as there is only a single date point.

On 1st Feb 2014, the price and unit costs will be different depending upon the buy/sell over that period. The minimum unit cost would be the min(Unit Costs) over the period 1st Jan - 1st Feb.

On 1st Mar 2014. the minimum unit costs would be the min (unit cost) between 1st Jan and 1st Mar

etc.

The expressions I tried:

1. MIN(Unit_Cost) - This is of course the same as Unit_Cost as there is only one unit cost for each date point

2. MIN(TOTAL Unit_Cost) - This is the minimum Unit_Cost between 1st Jan and 1st Jun. Not quite the same.

How do I achieve the Minimum of Unit_Cost between start date and the current date?

1 Reply
swuehl
MVP
MVP

Try an additional expression using chart inter record function above():

=rangemin( above(sum(Cost), 0, rowno() ))

assuming your expression for unit cost is sum(Cost).