Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am trying to get a listbox to show values depending on certain criteria in an expression. ie.
=if(FINISHED='Y',
if(STATUS = 'SS' OR STATUS = 'WW' OR STATUS = 'IN',
if((fabs(CURRENT_INTERRUPTION_STARTDATE-'22/09/2010') <= 35 or fabs('22/09/2010'-CURRENT_EXIT_DATE) <= 35),
'Withdrawn','Not Withdrawn')))
When I try select 'Withdrawn' or 'Not withdrawn' in the listbox(in red), nothing gets filtered in the application.
I think it's the Date criteria in the expression that is not correct. Although the logic seems to be fine.
Any ideas on how to correct this? I've attached the sample .qvw
Many thanks
Hi,
I would suggest you to include this calculation while loading the data.
As i can see from the table view you are using only 1 table. So the same expression will work for sure.
Regards,
Kaushik Solanki
Hi,
When you try the same expression in chart it works.
Can you describe how you want to use this. and whats the functional requirement, with example.
Regards,
Kaushik Solanki
Yes, it seems to work just fine in the chart.
I basically want a listbox with Withdrawn and Not withdrawn, using the specified criteria.
Hi,
I would suggest you to include this calculation while loading the data.
As i can see from the table view you are using only 1 table. So the same expression will work for sure.
Regards,
Kaushik Solanki
Hi Beanz,
Try this out.
1) Create a new field with (Current_Inspection_Date - '29/10/2010' ) as NewField
2) Add the new field to the condition and remove Current_Inspection_Date - '29/10/2010'.
This might work.
Deepak
Thanks, I'll try that out.
Hi Beanz,
This is my offer ... pls see attach
Good luck, Luis