Filter table box rows by range

[mokitsu61]

Hi

My question is about filtering rows of Tablebox.

Tablebox:

key | value

1 | A

2 | B

3 | C

4 | D

Listbox of "key":

1

2

3

4

When we select "3" of Listbox, Tablebox shows follow,

3 | C

* key = 3

But I want to make it as follow

3 | C

4 | D

* key >= 3

Does anyone know the way for it?

[sunny_talwar]

This won't be possible (or will need script changes) to do this in the table box... why not use a straight table instead?

[mokitsu61]

Hi, Sunny,

Thank you for your replying.

I(m not sticking to use Tablebox, I'm just want to show data in Table format.

So I couldn't find how to realize my requirement in Straight table too.

Do you have any ideas for it?

Thank you.

[sunny_talwar]

May be like this

Dimension

value

key

Expression

Avg({<key = {"='>=' & Min(key))"}>} 1)

and then you might be able to hide your expression from the presentation tab

[mokitsu61]

Sorry, I can't understand why AVE() function is used for it...

My original requirement is that we'd like to analyze [MY DATA] and this analysis needs data that selected date to 50 years future. And show target data in Table format.

Actually we can realize it by selecting whole KEY value we need which are in Listbox, but this idea is not good for me due to mis-operations.

* I know we can select tun of items on List box easily by putting ">XXXXXX" into search box of Listbox, but I think selecting over 18,000 items (365days * 50year) on Listbox will be no suitable for us...

MY DATA (Over 1,000,000 rows) :

KEY| VALUE

01-Apr-2010 | A

01-Apr-2010 | B

02-Apr-2010 | C

03-Apr-2010 | D

...

31-Mar-2050 | ZZZZZ

Thank you.

[sunny_talwar]

I get all that... and all you need is a straight table object with all your dimensions and just one dummy expression which will take care of your requirement. Does that make sense?

[mokitsu61]

Sorry again,

It make sense about using Straight table.

But I can't under stand your set analysis.

Do you know any references for it?

[sunny_talwar]

Check here

Set Analysis: syntaxes, examples

[mokitsu61]

Thanks, I'll check it.

[mokitsu61]

Hi Sunny,

> Avg([<key = {"='>' & Min(key))"}>} 1)

I couldn't find above format in your document...

Can you give me more hints about it?