Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
Can you post sample app also provide your expected output.
Regards
take this expression:
sum( if( aggr(nodistinct min(MonthNo), Product) = MonthNo, value, 0))
unfortunately, set analysis doen't work at this problem.
Regards
hi,
may be try this..
Create the variable like
vMonthNo : aggr(Min(MonthNo),Product) //(don't give equal sign)
Expression
=if(MonthNo=$(vMonthNo),Sales,'')
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;
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
Forgot the attachment.
Hi Tresesco,
Thanks for your response, but it didn't work.
I have attached the qvw for your reference.
Regards,
Padmanabhan
Hi Max,
I have attached the qvw for your reference.
Regards,
Padmanabhan
Hi
Thanks for your response, but it didn't work.
I have attached the qvw for your reference.
Regards,
Padmanabhan