Expression to find the next minimum value

[padmanabhan_ram]

Hi All,

I have a below table

MonthNo	Product	Sales
Jan-13	A	12
Feb-13	A	45
Mar-13	A	76
April-13	A	34
Feb-13	B	98
Mar-13	B	54
Apr-13	B	65

I am storing the Minimum MonthNo value in a 'vMonthNo' variable.

When I do "if(MonthName_Vol_Chart =vMonthNo,Sales,'') to get the Sale value for starting month.

I get the value for Product A as 12 but I do not get any value against Product B and I understand that it's because there no value for product B.

How can I make the expression flexible enough to get the values for the product B.

Note: There can be many Products like B which might have the same behaviour.

Thanks in advance,

Padmanabhan

[PrashantSangle]

Hi,

Can you post sample app also provide your expected output.

Regards

[martinpohl]

take this expression:

sum( if( aggr(nodistinct min(MonthNo), Product) = MonthNo, value, 0))

unfortunately, set analysis doen't work at this problem.

Regards

[settu_periasamy]

hi,

may be try this..

Create the variable like

vMonthNo    :    aggr(Min(MonthNo),Product)    //(don't give equal sign)

Expression

=if(MonthNo=$(vMonthNo),Sales,'')

[tresesco]

Use expression like:

=FirstSortedValue( Sales, MonthName_Vol_Chart)

With Product in dimension in chart, you would get the sale value for it's earliest date;

[padmanabhan_ram]

Hi All,

I do not get the value points with the suggestions provided.

Please find the attached qvw. I want the line graph to show the values on the data points of starting month and ending month.

Regards,

Padmanabhan

[padmanabhan_ram]

Forgot the attachment.

[padmanabhan_ram]

Hi Tresesco,

Thanks for your response, but it didn't work.

I have attached the qvw for your reference.

Regards,

Padmanabhan

[padmanabhan_ram]

Hi Max,

I have attached the qvw for your reference.

Regards,

Padmanabhan

[padmanabhan_ram]

Hi

Thanks for your response, but it didn't work.

I have attached the qvw for your reference.

Regards,

Padmanabhan