topic Getting Min values for the remaining dataset in QlikView

Getting Min values for the remaining dataset

Tue, 20 Apr 2010 08:10:43 GMT

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

Wed, 21 Apr 2010 06:41:53 GMT

Someone pls help

Getting Min values for the remaining dataset

sunil2288 — Wed, 21 Apr 2010 06:49:19 GMT

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

Wed, 21 Apr 2010 06:56:54 GMT

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

sunil2288 — Wed, 21 Apr 2010 09:53:54 GMT

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

Wed, 21 Apr 2010 10:08:29 GMT

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

sunil2288 — Wed, 21 Apr 2010 10:46:36 GMT

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

Wed, 21 Apr 2010 11:59:08 GMT

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

Tue, 27 Apr 2010 07:51:43 GMT

hi umang,

pls see the attached application.

probably this should work fine

thanks

Getting Min values for the remaining dataset

Tue, 27 Apr 2010 10:38:18 GMT

Thanks Tauqueer - exactly what I wanted

Getting Min values for the remaining dataset

Tue, 27 Apr 2010 11:01:27 GMT

Umang,

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

regards,

Mukund