10 Replies Latest reply: Apr 27, 2010 7:01 AM by MBharambe

# Getting Min values for the remaining dataset

Hi,

Have a small problem, I need to calculate the minimum values of the dataset corresponding to the value as of today. Let me explain with an example

 Date Value Min Value 1 101 2 110 105 3 105 4 109 5 115 109 6 117 109 7 109 8 120 111 9 111 10 130

On Day 1 the value is 101 and there is no value lesser than 101, so min value is blank.

On Day 2 the value is 110 and for the remaining period the min value is 105, so selected Min Value is 105

On Day 3 the value is 105 and for the remaining period the min value is 105, so Min Value is blank

Similarly on Day 5 the value is 115 and for the remaining period the min value is 109, so selected Min Value is 109

How to get such values in QV?

• ###### Getting Min values for the remaining dataset

Someone pls help

• ###### Getting Min values for the remaining dataset

Hi Umang,

Can u plz tell me the structure of ur database.. What does the 'value' stand for and what does the min value stand for ..

• ###### Getting Min values for the remaining dataset

HI Umang,

If i am not wrong u hav three fields date,start value , all values in a day...

After loading these 3 data field ..create a straight table having dimensions Date , Value..

Then edit expression as

`if(Value >min([Values in D day]),min([Values in D day]),'')`

Then you can get the Desired output ..

I am sending u the .qvw file

Cheers

Sunil..

• ###### Getting Min values for the remaining dataset

Sunil,

thanks for the effort you are putting for solving my query, but I guess i have not been able to explain the same properly.

Min Value is a calculated value based on the Values field. I am attaching an excel example to showcase how the Min Value is calculated.

thanks

• ###### Getting Min values for the remaining dataset

HI Umang

I have done exactly what u want ..U down load the attatched .qvw and go through it..

I am also sending u the generated out put of the required information u need.

• ###### Getting Min values for the remaining dataset

Hi Sunil,

I think there is stil some misunderstanding, in the QV you have got three fileds

1. Date

2.Start Value

3. All the values of the

However my data has got just two sets of values

1. Date

2. Values

The Min value is calculated as per the formulas I have written in the attached excel file

thanks

• ###### Getting Min values for the remaining dataset

Thanks Tauqueer - exactly what I wanted

• ###### Getting Min values for the remaining dataset

Hi Sunil,

The value stands for the prices of a product which may rise or fall as per the demand & supply

The Min Value stands for the lowest price of the commodity after the date at which it is calculated so at every point of time may change

• ###### Getting Min values for the remaining dataset

hi umang,

pls see the attached application.

probably this should work fine

thanks

• ###### Getting Min values for the remaining dataset

Umang,

You can do this using the "previous" function as well. Please see attached.

regards,

Mukund