Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
If you are a Qlik Insight Bot user, join this collaborative group: JOIN GROUP
Contributor

Filter table box rows by range

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?

13 Replies
Highlighted

Re: Filter table box rows by range

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

Highlighted
Contributor

Re: Filter table box rows by range

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.

Highlighted

Re: Filter table box rows by range

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

Highlighted
Contributor

Re: Filter table box rows by range

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.

Highlighted

Re: Filter table box rows by range

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?

Highlighted
Contributor

Re: Filter table box rows by range

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?

Highlighted

Re: Filter table box rows by range

Highlighted
Contributor

Re: Filter table box rows by range

Thanks, I'll check it.

Highlighted
Contributor

Re: Filter table box rows by range

Hi Sunny,

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

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

Can you give me more hints about it?