Range

[#1]

Hi Guys,

I have 2 variabls(From and To) If I have to use range of values between from and To. How can I use it as an expression?

Please anybody help on this

Thanks

[#2]

Please any body help on this

[Jason_Michaelides]

Hi - can you be more specific about what you want to do?  If you want a listbox of all values between the two variable then you can create a listbox using the expression ValueLoop(vFrom,vTo).

Or you may need to create real data points in the script (unless the variable can change).

Hard to help without detail.

[#4]

I have a grid chart,

y axis as 0 to 23 and x axis as sun, mon to sat.

If any user enter 10 to 15 in the input box I want 10 to 15 in the chart to be highlighted.

I used the reference lines in the presentation tab, but need to know the function to be used to accept this range 10 to 15.

Thanks

[Jason_Michaelides]

What version are you using?  Can you post your app?

[#6]

version: 9 and attached is the screen shot. Tried with the valueloop. No Joy:(

Any info please let me know..

Thanks

[sivarajs]

u can use set analysis for range

try this like....

sum({$<field= {'>=10<=15'}>}field)

Sivaraj S

[Jason_Michaelides]

Can't you just allow users to select HOUROFDAY?  Do you need to use variables vFrom and vTo?

If so, I guess your current expression is something like COUNT(something)

Try COUNT({<HOUROFDAY={">=vFrom<=vTo"}>}  something)

[Jason_Michaelides]

(Would help if you can post your app with some data in it)

[#10]

HI,

you can use it in set analysis as:

Sum({$<Date={">=$(=Date($(vfrom)))<=$(=Date($(=vto)))"}>}Sales)

This expression sum up the sales where date is between vfron and vto (Two variables selected by user with the hepl of calender)

Hope this help...

Regards

Arun Goel