Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
hi umang,
pls see the attached application.
probably this should work fine
thanks
Someone pls help
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 ..
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
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..
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
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.
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
hi umang,
pls see the attached application.
probably this should work fine
thanks
Thanks Tauqueer - exactly what I wanted