Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Try This,
=only({<Key={">=$(=Key)<=$(=max({<Key=>}Key))"}>}Value)
Regards,
Thank you for your replying.
How specify the value of [Value] when [Value] are several items?
I'm really happy by your response and I want to realize your advice on my PC.
MY DATA (Over 1,000,000 rows) :
KEY| VALUE1 | VALUE2
01-Apr-2010 | A | a
01-Apr-2010 | B | b
02-Apr-2010 | C | c
03-Apr-2010 | D | d
...
31-Mar-2050 | ZZZZZ | zzzzz
Thank you.
Hi,
I hope this is what you are asking, Keep the Dimension as Key and add 2 expressions here,
=only({<Key={">=$(=Key)<=$(=max({<Key=>}Key))"}>}Value1),
=only({<Key={">=$(=Key)<=$(=max({<Key=>}Key))"}>}Value2)
Regards,
Thanks!