display the list box based on conditions

[stephenedberkg]

I have Uploaded week each upload week have 24 week data

first 12 weeks are history week next 12 weeks are forecast week,

I want to show last 12 weeks in list box.

ex:

my Uploaded week is 24 means

it have 24 week

12 to 23 weeks are History.

24 to 35 are forecast weeks.

if i selected the Uploaded week 24 means i want to show weeks 24 to 35 week in list box,

Help me

Thanks in advance

[Anonymous]

Hi Stephen,

You can add an Expression into list box.

IF(Interval(vMaxUploadedWeek-Week,'W')>=0 and Interval(vMaxUploadedWeek-Week,'W')<=12,Week)

Kind Regards!

[Anonymous]

Hi Stephen,

Can you provide us a QVW file to play around with ?

Regards,

Filip